The UNIX and Linux Forums
Forum Home
Linux and Unix Man Pages
Search Forums
Search Community Posts
Today's Posts
Quick Links
Man Pages
RedHat Commands
OpenSolaris Commands
Linux Commands
SunOS Commands
FreeBSD Commands
All UNIX Man Pages
All Linux Man Pages
Full Man Repository
Login or Register to Ask a Question and Join Our Community
Search Forums
Show Threads .
Show Posts
Tag Search
Advanced Search
Quick Links
Contact Us
Forum Rules
Today's Posts
FAQ
Pictures & Albums
All Albums
Miscellaneous
What is My IP
Whois
Mark Forums Read
Search Results
Showing results 1 to 1 of 1
Search took
0.00
seconds.
Search:
Posts Made By:
wxornot
Forum:
Programming
01-29-2013
3
Psql replace blanks with character
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
Member Badges and Information Modal
×