| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Marek Lewczuk <newsy(at)lewczuk(dot)com> |
| Cc: | Lista dyskusyjna pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: CONCAT function |
| Date: | 2003-09-16 13:51:55 |
| Message-ID: | 200309161451.55262.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tuesday 16 September 2003 14:35, scott.marlowe wrote:
> On Tue, 16 Sep 2003, Marek Lewczuk wrote:
> > Hello,
> > As I'm in the middle of the migration process form mysql to pg I found
> > that there is no CONCAT function which is available in mysql. Can
> > anybody tell me how to implement this function using plPERL or plPGSQL
> > language ?
>
> What's wrong with using the SQL spec || operator?
Because in mysql, SELECT 'a' || 'b' is treated as 'a' OR 'b' and you end up
with a return value of 0. Ho hum.
If I had to choose between coding concat() for PG or the standard operator for
mysql, I think I'd do the same.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lamar Owen | 2003-09-16 13:52:59 | Re: State of Beta 2 |
| Previous Message | Marek Lewczuk | 2003-09-16 13:50:50 | Re: CONCAT function |