Re: CONCAT function

On Tue, 16 Sep 2003, Richard Huxton wrote:

> 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.

there's a switch in MySQL that makes it behave properly.

Given the third choice, I'd throw the switch.