[postgis-users] INSERT geom Problem

[Mike Leahy]

Levert,

I think you can cast the text as geometry as follows:

INSERT INTO "popplace"
("unique_key","name","the_geom") VALUES
('124','London','SRID=27582;0101000000000000A053984241000000C0789A3141'::geometry);


Mike

Levert Donovan wrote:

>Hello,
>This is the continuation of the message Postgis
>Problem , I continued on the problem and I discover
>where is the problem. 
>
>It is a problem from INSERT and the AddGeometryColumn.
>
>this INSERT works fine : 
>INSERT INTO "popplace"
>("unique_key","name","the_geom") VALUES
>('128','pari',GeometryFromText('POINT(0 0
>0)',27582));
>
>But this INSERT doesn't work : 
>INSERT INTO "popplace"
>("unique_key","name","the_geom") VALUES
>('124','London','SRID=27582;0101000000000000A053984241000000C0789A3141');
>
>Do you what is the format of
>'SRID=27582;0101000000000000A053984241000000C0789A3141',
>how can I convert this to GeometryFromText() function
>?
>
>Best Regards.
>Donovan LEVERT
>
>
>	
>
>	
>		
>___________________________________________________________________________ 
>Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
>Téléchargez cette version sur http://fr.messenger.yahoo.com
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>  
>