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


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to