| From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | "'Richard Huxton'" <dev(at)archonet(dot)com>, "'Lista dyskusyjna pgsql-general'" <pgsql-general(at)postgresql(dot)org>, <newsy(at)lewczuk(dot)com> |
| Subject: | Re: CONCAT function |
| Date: | 2003-09-16 12:47:00 |
| Message-ID: | 3F67539C.247.24B7B8@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2003-09-16 12:53:39 | Re: CONCAT function |
| Previous Message | Marek Lewczuk | 2003-09-16 12:45:19 | CONCAT function |