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