[postgis-users] INSERT geom Problem

[Levert Donovan]

> What does "SELECT version()" spit out?
$psql  -U mapuser mapcanada
mapcanada=> SELECT version();
version
---------------------------------------------------------------------------------------------------------
 PostgreSQL 7.4.7 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
(1 row)

> Try setsrid() function:
> lwgeom=# 
>select
>setsrid('0101000000000000A053984241000000C0789A3141'::geometry,27582);

I can't do the SELECT because the INSERT doesn't
works. 
select
setsrid('0101000000000000A053984241000000C0789A3141'::geometry,27582);


Best Regards.
Donovan LEVERT

--- Markus Schaber <schabi at logix-tt.com> a écrit :

> Hi, Levert,
> 
> Levert Donovan wrote:
> 
>  > 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
> > ?
> >
> Try setsrid() function:
> 
> lwgeom=# select
>
setsrid('0101000000000000A053984241000000C0789A3141'::geometry,27582);
>                       setsrid
> ----------------------------------------------------
>  0101000020BE6B0000000000A053984241000000C0789A3141
> 
> 
> Alternatively, produce the Hex-EWKB containing the
> SRID yourself.
> 
> HTH,
> Schabi
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
>
http://postgis.refractions.net/mailman/listinfo/postgis-users
> 



	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com