Re: coalesce function
| От | Serge Fonville |
|---|---|
| Тема | Re: coalesce function |
| Дата | |
| Msg-id | CAOAS_+KYNB+nNXf68PWD4Yv01z+D4rRVYDpuiB4wkUbdQzKH4w@mail.gmail.com обсуждение исходный текст |
| Ответ на | coalesce function (itishree sukla <itishree.sukla@gmail.com>) |
| Список | pgsql-general |
Hi,
http://www.postgresql.org/docs/9.1/static/functions-conditional.html describes NULLIF, when combined with COALESCE it should answer your request.
HTH
http://www.sergefonville.nl
Convince Microsoft!
http://www.postgresql.org/docs/9.1/static/functions-conditional.html describes NULLIF, when combined with COALESCE it should answer your request.
HTH
Kind regards/met vriendelijke groet,
Serge Fonville
Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server
2013/6/20 itishree sukla <itishree.sukla@gmail.com>
Hi All,I am using coalesce(firstname,lastname), to get the result if first name is 'NULL' it will give me lastname or either way. I am having data like instead of NULL, blank null ( i mean something like '' ) for which coalesce is not working, is there any workaround or other function available in postgresql, please do let me know.Regards,Itishree
В списке pgsql-general по дате отправления: