Programming

Well as the title describes, its a pretty straight forward problem. I have a series of psql tables where there are lots of blanks. However there is at least one column, called name, that will never be blank. I want to write a select statement to get all of the contents of the table and then turn blanks into a string like NULL. Here is my select statement idea, but I just don't have a strong enough grasp on how the statement should look:


SELECT name,date,value
FROM table
WHERE value=' ' print as "NULL";


I don't want to update the actual table, just print it without blanks. Obviously the above code doesn't work, but hopefully you get the idea. I appreciate the help.

Dave

Use condition:

Code:

SELECT name,date,value FROM table where nvl(length(trim(value)),0)=0

to identify blank values.

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,

Dave

Does it support "case when ... then ...."?