Re: [GENERAL] plpgsql string concatanation
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
Re: [GENERAL] 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. > See my recent post at http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=24725 (and in general, everyone here who hasn't looked at http://www.brasileiro.net/postgres/cookbook/ should review all the great goodies posted there). ~Berend Tober ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] 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" <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings