From: Richard Huxton <dev@archonet.com>
To: email_daniel_h@yahoo.com.br, pgsql-sql@postgresql.org
Subject: Re: Functional index and string concatenation
Date: Mon, 8 Mar 2004 17:38:46 +0000
User-Agent: KMail/1.5
References: <404C8F08.2070403@yahoo.com.br>
	<1078759686.10233.1.camel@elb_lx.onesystem.ca>
	<404C992D.1060407@yahoo.com.br>
In-Reply-To: <404C992D.1060407@yahoo.com.br>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200403081738.46011.dev@archonet.com>

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