What is the PostgreSQL equivalent for ISNULL()

by 
SELECT CASE WHEN field IS NULL THEN 'Empty' ELSE field END AS field_alias

Or more idiomatic:

SELECT coalesce(field, 'Empty') AS field_alias

More Related Contents:

  1. Altering a column: null to not null
  2. How much size “Null” value takes in SQL Server
  3. SQL Server String Concatenation with Null
  4. How to get difference of days/months/years (datediff) between two dates?
  5. How to migrate a PostgreSQL database into a SQLServer one?
  6. migrate data from MS SQL to PostgreSQL?
  7. Max Nbr of Months W/ No Activity in Past 12 Months
  8. Export from SQL Server to Excel
  9. SQL server query to output the data shown below
  10. hide/remove header and footer
  11. How to use a variable for the database name in T-SQL?
  12. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  13. SQL Server: SELECT only the rows with MAX(DATE)
  14. Create a view with ORDER BY clause
  15. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  16. INSERT INTO vs SELECT INTO
  17. Possible to store value of one select column and use it for the next one?
  18. Sorting null values after all others, except special
  19. How to view transaction logs in SQL Server 2008 [closed]
  20. Scheduled run of stored procedure on SQL server
  21. How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
  22. How can I Insert data into SQL Server using VBNet
  23. Will GETUTCDATE() return the same value if used twice in the same statement?
  24. Convert decimal time to hours and minutes
  25. Create table (structure) from existing table
  26. Milliseconds wrong when converting from XML to SQL Server datetime
  27. Using GROUP BY with FIRST_VALUE and LAST_VALUE
  28. SQL Server 2008 can’t login with newly created user
  29. What is the difference between Cartesian product and cross join?
  30. Count number of records returned by group by

Leave a Comment