From: Richard Huxton <dev@archonet.com>
To: email_daniel_h@yahoo.com.br
To: pgsql-sql@postgresql.org
Subject: Re: Functional index and string concatenation
Date: Mon, 8 Mar 2004 17:38:46 +0000
Message-ID: <200403081738.46011.dev@archonet.com> (raw)
In-Reply-To: <404C992D.1060407@yahoo.com.br>
References: <404C8F08.2070403@yahoo.com.br>
<1078759686.10233.1.camel@elb_lx.onesystem.ca>
<404C992D.1060407@yahoo.com.br>
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
> function in the index definition can take more than one argument, but
> they must be table columns, not constants" and "there cannot be
> multicolumn indexes that contain function calls".
>
> Maybe i should to create a new pgsql function.
Yes - a wrapper function is the standard solution. I don't think you need to
do this in 7.4 though.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, email_daniel_h@yahoo.com.br
Subject: Re: Functional index and string concatenation
In-Reply-To: <200403081738.46011.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox