[postgis-users] Strange type casts

[Charlie Savage]

Install postgis and make sure it is on your search path.

Then run this query:

select 'abc'::text = decode('YWJj', 'base64')

Its results in this:

ERROR:  parse error - invalid geometry

********** Error **********

ERROR: parse error - invalid geometry
SQL state: XX000


I see that postgis defines the = operator between two geometries.  Which 
seems to mean that the text on the left side is converted automatically 
to a geometry and the bytea on the right side to a geometry 
automatically.  That's surprising to say the least...

Charlie
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3237 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090416/7353c6f6/attachment.bin>