Re: CONCAT function - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: CONCAT function
Date
Msg-id 3F67539C.247.24B7B8@localhost
Whole thread Raw
In response to Re: CONCAT function  ("Marek Lewczuk" <newsy@lewczuk.com>)
Responses Re: CONCAT function  ("Marek Lewczuk" <newsy@lewczuk.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: "Marek Lewczuk"
Date:
Subject: Re: CONCAT function
Next
From: "Marek Lewczuk"
Date:
Subject: Re: CONCAT function