Search Results

Search: Posts Made By: wxornot
Forum: Programming 01-29-2013
1,843
Posted By wxornot
NVL isn't supported with psql according to what...
NVL isn't supported with psql according to what I've read, but your example keyed me in on how to use coalesce. This did the trick.


SELECT name,date,coalesce(value,0) FROM table;


Regards,...
Showing results 1 to 1 of 1

 
All times are GMT -4. The time now is 07:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy