Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA04098 for ; Wed, 26 May 1999 10:08:23 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA12811; Wed, 26 May 1999 10:07:42 -0400 (EDT) To: emils@mail.usis.bkc.lv cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] CASE WHEN / 6.4.2? + no doc in installed documentation In-reply-to: Your message of Wed, 26 May 1999 15:50:09 EET <199905261245.PAA07938@omega.bkc.lv> Date: Wed, 26 May 1999 10:07:41 -0400 Message-ID: <12809.927727661@sss.pgh.pa.us> From: Tom Lane "Emils Klotins" writes: > Could somebody please tell what is the correct form for either IFNULL > or CASE SQL functions in PG? Looking in the grammar I find: /* Case clause * Define SQL92-style case clause. * Allow all four forms described in the standard: * - Full specification * CASE WHEN a = b THEN c ... ELSE d END * - Implicit argument * CASE a WHEN b THEN c ... ELSE d END * - Conditional NULL * NULLIF(x,y) * same as CASE WHEN x = y THEN NULL ELSE x END * - Conditional substitution from list, use first non-null argument * COALESCE(a,b,...) * same as CASE WHEN a IS NOT NULL THEN a WHEN b IS NOT NULL THEN b ... END * - thomas 1998-11-09 */ I think these things will actually be documented in 6.5 :-). BTW, there are some severe bugs in CASE in 6.4.*; it doesn't work reliably in queries that reference more than one table. Fixed in 6.5, as far as I know. regards, tom lane