Re: plpgsql string concatanation

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.

Best wishes,
CHris Travers
----- Original Message -----
From: "Martin Marques" <martin@bugs.unl.edu.ar>

As I said, it was in front of me, and the tree didn't let me see the
forest. :-)

--
 09:43:01 up 2 days, 16:07,  1 user,  load average: 1.14, 1.34, 1.07
-----------------------------------------------------------------
Martín Marqués        | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica  |  DBA, Programador, Administrador
             Universidad Nacional
                  del Litoral
-----------------------------------------------------------------


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings