Christopher Kings-Lynne writes:
> lkindness(at)csl(dot)co(dot)uk writes:
> > SELECT COALESCE(MAX(id), 0) + 1 from test;
> > can be replaced by the following PostgreSQL query:
> > SELECT COALESCE(MAX(id), 0) + 1 from test;
> Ummm...did you make a mistake here? 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.