Re: Functional index and string concatenation

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