Re: Concatenating two Text fields from the same tuple - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Concatenating two Text fields from the same tuple
Date
Msg-id 20030703200156.GN1561@libertyrms.info
Whole thread Raw
In response to Concatenating two Text fields from the same tuple  (psql-mail@freeuk.com)
List pgsql-general
On Thu, Jul 03, 2003 at 06:16:35PM +0100, psql-mail@freeuk.com wrote:
> Question 2: If not - is it possible for me to concatenate attr1 and
> attr2 before i do the search as this would remove the logic problems. (
> and if it is possible - is it efficient?)

I don't know the answer to your other problems, but the "||" operator
allows you to concatenate.  And "where field1||field2 = 'something'"
works.  Whether it'd be efficienct is another question.  Maybe you
could do something fancy with a partial index or something, but I
can't think how.

A

----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Rollback for aborted function?
Next
From: elein
Date:
Subject: Re: Are we backwards on the sign of timezones?