[postgis-users] Difference between "Geometry" and "BLOB" in Postgis

Sandro Santilli strk at keybit.net
Sat Nov 1 06:10:20 PDT 2014

On Fri, Oct 31, 2014 at 05:12:40PM -0400, Robert Burgholzer wrote:
> So just for accuracy, I was incorrect, sort of.  While the functions that I
> am currently using "contains, within, ..." will do the CAST implicitly, the
> GIST index does not like the bytea type.  Which makes the adoption of an
> actual geometry column even more urgent.

For further accuracy, you might pass the GiST index an expression, then
it'll like it. Example:

 create index on mytable using gist (geometry(mybytea));
 explain select gid from mytable where mybytea && ST_MakeEnvelope(0,0,1,1);


More information about the postgis-users mailing list