Re: Functional index and string concatenation

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 <ebacon(at)onesystem(dot)com>