On Mon, 2004-03-08 at 08:19, Daniel Henrique Alves Lima wrote: > Is there a way to create a "functional index" over a string > concatenation of two columns ? > > Thanks. > Like this?
test=# create table strtable (x int, str1 text, str2 text); CREATE TABLE test=# create index str_idx on strtable( textcat(str1, str2) ); CREATE INDEX test=# -- Edmund Bacon <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
