Re: CONCAT function

On 16 Sep 2003 at 14:36, Marek Lewczuk wrote:

> >
> > You want to use the || operator, e.g. 'hello' || ' ' || 'world'
>
> I know that, but in my application (which is working on MySQL now) I
> have many querys which use CONCAT function, so I need to implement this
> function is PG - there is no possibility to replace (in short time) all
> of my querys.

Write your own function..

something like

text concat(text,text)

 return text1 || text2

Check up the syntax but you got the idea..

Bye
 Shridhar

--
Friends, n.:    People who borrow your books and set wet glasses on them.    People
who know you well, but like you anyway.