[postgis-users] Is there a difference between geomFromText and GeometryFromText?

Willem Nieuwenhuis nieuwenhuis at itc.nl
Mon Jun 26 05:54:02 PDT 2006


When experimenting with entering features into PostGIS, I encountered a
difference in behaviour between GeomFromText and GeometryFromText. In my
understanding the first should only be a shorthand notation for the
second.
But when I combine both notations (in a SQL script) only the
GeometryFromText function adds (valid) geometries.
For example:

insert into bugplaces (gid,ID,CAT_ID,the_geom) values
('89','90','90',GeometryFromText('POINT (7.3618176 44.3867629)','0') );
INSERT INTO bugplaces(gid,the_geom,class)
VALUES('100',GeomFromText('POINT (11.582294629385492
42.33848278926086)','0'),'Amphibia');

The first geometry is OK, but the second not. In uDIG I only see the
first point.

Is there supposed to be a difference?

Willem Nieuwenhuis
 



More information about the postgis-users mailing list