Re: IFNULL -> COALESCE
От
Christopher Kings-Lynne
Тема
Re: IFNULL -> COALESCE
Дата
Msg-id
20020209011111.J14715-100000@houston.familyhealth.com.au
Ответ на
IFNULL -> COALESCE (Lee Kindness)
Список
Дерево обсуждения
IFNULL -> COALESCE Lee Kindness <lkindness@csl.co.uk>
Re: IFNULL -> COALESCE Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: IFNULL -> COALESCE Lee Kindness <lkindness@csl.co.uk>
Re: IFNULL -> COALESCE Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: IFNULL -> COALESCE Tom Lane <tgl@sss.pgh.pa.us>
Re: IFNULL -> COALESCE Lee Kindness <lkindness@csl.co.uk>
Re: IFNULL -> COALESCE "Ross J. Reedstrom" <reedstrm@rice.edu>
Re: IFNULL -> COALESCE Peter Eisentraut <peter_e@gmx.net>
Re: IFNULL -> COALESCE Tom Lane <tgl@sss.pgh.pa.us>
sqlca warning (was Re: IFNULL -> COALESCE) Peter Eisentraut <peter_e@gmx.net>
sqlca warning (was Re: IFNULL -> COALESCE) Lee Kindness <lkindness@csl.co.uk>
Re: sqlca warning (was Re: IFNULL -> COALESCE) Tom Lane <tgl@sss.pgh.pa.us>
> Guys, I've recently being going back over code from Ingres and porting > it over to PostgreSQL. Heavy use was made of the IFNULL function, this > function simply returns the 2nd argument if the first is > NULL. Consider the following query: > > 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... Chris
В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата:
