| From: | "Chris Travers" <chris(at)travelamericas(dot)com> |
|---|---|
| To: | "Martin Marques" <martin(at)bugs(dot)unl(dot)edu(dot)ar>, "Doug McNaught" <doug(at)mcnaught(dot)org> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: plpgsql string concatanation |
| Date: | 2003-11-28 13:38:32 |
| Message-ID: | 00b501c3b5b4$f7e708c0$df44053d@SAMUEL |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)bugs(dot)unl(dot)edu(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig O'Shannessy | 2003-11-28 13:57:49 | Re: disaster recovery |
| Previous Message | Philippe Lang | 2003-11-28 13:29:22 | Restore-point? |