[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Strange type casts
From:       Charlie Savage <cfis () savagexi ! com>
Date:       2009-04-17 20:55:20
Message-ID: 49E8ECB8.8030103 () savagexi ! com
[Download RAW message or body]

Install postgis and make sure it is on your postgresql 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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]