check for null value

[Ashok Chauhan]

hello

i am selecting ten fields form a table and i want to replace the null
values with any other value.

plz. help me

Ashok


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[scott.marlowe]

Post by Ashok Chauhan
hello
i am selecting ten fields form a table and i want to replace the null
values with any other value.

Look up coalesce(), it should do exactly what you need.


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org