am Thu, dem 12.10.2006, um 18:40:22 -0700 mailte Niederland folgendes: > I am using postgresql 8.1.4. > > Is there anyway to create an index equivalent to: > CREATE INDEX i1 ON t1 USING btree (ts::Date);
CREATE INDEX i1 ON t1 USING BTREE (to_char(ts, 'dd-mm-yyyy' )); *untested* Please, let me know, if this okay. HTH, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
