Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > Is it possible to make a composite GiST index? I want to create an > index on a txtidx and a timestamp column - is that at all possible?
Yeah. If you have a problem with that, it's grounds for a bug report. Note though that GiST can't handle entries with NULL in the first column, so it's best to put a NOT NULL column first if possible. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html