Re: IFNULL -> COALESCE

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.