Re: plpgsql string concatanation
От | Chris Travers |
---|---|
Тема | Re: plpgsql string concatanation |
Дата | |
Msg-id | 00b501c3b5b4$f7e708c0$df44053d@SAMUEL обсуждение исходный текст |
Ответ на | plpgsql string concatanation (Martin Marques <martin@bugs.unl.edu.ar>) |
Ответы |
Re: plpgsql string concatanation
Re: plpgsql string concatanation |
Список | 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@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
В списке pgsql-general по дате отправления: