Re: IFNULL -> COALESCE

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.