Replacing NULL values with default values

SELECT COALESCE(description, short_description, ‘(none)’)

PostgreSQL: Documentation: Manuals: PostgreSQL 8.0: Conditional Expressions

Leave a Reply