Andrus wrote: > Can Postgres use index > > CREATE UNIQUE INDEX foo_bar ON foo(bar bpchar_pattern_ops); > > in usual WHERE expressions just like regular index ? > > I.e can > > SELECT * FROM foo WHERE bar='123' > > use index foo_bar ?
I think in the time it took you to write this email you could have typed in those lines into psql and found out yourself. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
