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
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
