Replacing NULL values with default values
SELECT COALESCE(description, short_description, ‘(none)’)
PostgreSQL: Documentation: Manuals: PostgreSQL 8.0: Conditional Expressions
SELECT COALESCE(description, short_description, ‘(none)’)
PostgreSQL: Documentation: Manuals: PostgreSQL 8.0: Conditional Expressions