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