On Monday 08 March 2004 16:02, Daniel Henrique Alves Lima wrote:
> Yes, i was searching for the name of equivalent function to "||"
> operator...
>
> Now, i've got a new problem: I need to concat three values (two
> column values and a sepator constant). But from documentation: " The
> func
Edmund Bacon <[EMAIL PROTECTED]> writes:
> 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 ?
> test=# create index str_idx on strtable( textcat(str1, str2) );
As of 7.4 you can do it mor
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
Is there a way to create a "functional index" over a string
concatenation of two columns ?
Thanks.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
