Re: plpgsql string concatanation - Mailing list pgsql-general

From Martin Marques
Subject Re: plpgsql string concatanation
Date
Msg-id 200311281125.40792.martin@bugs.unl.edu.ar
Whole thread Raw
In response to Re: plpgsql string concatanation  ("Chris Travers" <chris@travelamericas.com>)
List pgsql-general
El Vie 28 Nov 2003 10:38, Chris Travers escribió:
> One thing that I always have to remind myself of is this:
>
> string || NULL  is NULL.
> It is usually a good idea to use coalesce() unless you want this to happen.

Pretty nice. :-)
Even though I don't have that problem, becuase the value comes from a PK
field.

--
 11:24:01 up 2 days, 17:48,  1 user,  load average: 0.56, 0.62, 0.63
-----------------------------------------------------------------
Martín Marqués        | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica  |  DBA, Programador, Administrador
             Universidad Nacional
                  del Litoral
-----------------------------------------------------------------


pgsql-general by date:

Previous
From: Thierry Missimilly
Date:
Subject: Re: What is WAL used for?
Next
From: Paul Thomas
Date:
Subject: Re: PostgreSQL Advocacy, Thoughts and Comments