Sqlite IFNULL () in postgres

Question

What's the equivalent of SQLite IFNULL()

in Postgres?

I need to execute a query (sqlite in Ruby):

SELECT ifnull(max(code_id) + 1, 1) 
FROM configentries 
WHERE configtable_id = ...

What would it look like if I want to get the same result with PostgreSQL?

+3

RagnarLothbrok May 12 '17 at 9:29

1 answer

Vao tsun · Accepted Answer · 2017-05-12T09:33:12+0000

try coalesce

:

The COALESCE function returns the first of its arguments, which is not zero. Null is returned only if all arguments are null

sql = "SELECT coalesce(max(code_id) + 1, 1) FROM configentries WHERE configtable_id = " + table_id