[postgis-users] Help initialize PostGIS with lwpostgis.sq l

[strk at refractions.net]

On Sat, Nov 11, 2006 at 12:17:15PM +0800, alex_chew wrote:

> I tried to query some geometry data with SQL,
> SELECT name, AsSVG(intersection(Simplify(the_geom,20),GeometryFromText("POLYGON((104 30,105 30,105 32,104 32,104 30))",4326)),1,1) AS svg_geom FROM river WHERE the_geom && setSRID("BOX3D(104 30, 105 32)"::box3d,4326)
> 
> Error message i got is,
> ERROR:  column "POLYGON((104 30,105 30,105 32,104 32,104 30))" does not exist

Literal strings need to be quoted with single quotes:

	'POLYGON....'

Double-quotes are used to specify identifiers, like column names:

	"My Column Name With Spaces And Mixed Case"

So you're trying to reference a column names "POLYGON..." and
the SQL parser is raising an error on that.

--strk;