Thanks Baris.... here are the two table definitions:
-- Using default PostgreSQL geometric types
create table gis.cities (
id serial primary key,
name varchar(50),
state varchar(2),
geom point
);
-- Using PostGIS geometry types
create table gis.table_pt (
id serial primary key,
name varchar(50),
state varchar(2),
geom geometry(Point)
);
The select query below only worked when run against the PostGIS geometry
type:
SELECT id, name FROM gis.table_pt WHERE ST_DWithin(
geom,
ST_GeomFromText('POINT(0 0)', 26910),
1000
);
--
View this message in context:
http://postgis.17.x6.nabble.com/PostgreSQL-geometric-data-types-vs-GEOMETRY-data-type-tp5005378p5005381.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
