Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > OK, this is what I'm trying (7.3.4): > create index blah on forums_posts using gist(ftiidx, datetime); > ERROR: data type timestamp with time zone has no default operator class > for access method "gist"
That's got nothing to do with it being a two-column index --- it's that GiST doesn't know what to do with a timestamptz, in any column. I see that there is support for timestamp without time zone in contrib/btree_gist --- probably it would be a simple matter to extend that to timestamp with time zone. But it's not there today (much less in 7.3 ;-)) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]