[postgis-users] Problem with geodata storage

[Emilio Ponce]

Hi everyone, here Emilio from Barcelona,

I've found a problem with my postgresql+postgis under ubuntu. When I
tried to store a geometry worked well, but when I tried to get this
data with a select I found this strange numbers:

testgis=# select * from calles_geom;

 id |  name   |                                        geom
----+---------+------------------------------------------------------------------------------------
  1 | Jeff Rd |
01020000000200000000000000005807410000000070AD0D4100000000205407410000000050B10D41
(1 fila)


I've done this to store the data:

CREATE TABLE CALLES_GEOM(
	ID int4,
	NAME varchar(25)
);

SELECT AddGeometryColumn('calles_db','calles_geom','geom','-1', 'LINESTRING',2);

BEGIN;
INSERT INTO CALLES_GEOM(ID,GEOM,NAME) VALUES (1,
GeometryFromText('LINESTRING(191232 243118,191108 243242)',-1),'Jeff
Rd');
END;


Then,anyone know why the geom column is not 'LINESTRING(191232
243118,191108 243242)'?

Thanks!


-- 
Emilio