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