Christopher Kings-Lynne writes:> lkindness@csl.co.uk writes:> > SELECT COALESCE(MAX(id), 0) + 1 from test;> > can be
replacedby the following PostgreSQL query:> > SELECT COALESCE(MAX(id), 0) + 1 from test;> Ummm...did you make a
mistakehere? Those statements are> identical...
Okay, lets try that again...
SELECT IFNULL(MAX(id), 0) + 1 from test;
can be replaced by the following PostgreSQL query:
SELECT COALESCE(MAX(id), 0) + 1 from test;
Thanks, Lee.
