From 51972a9d5d068dd34b24ff4923981ffb90e5cc2d Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 16 Feb 2003 02:30:39 +0000 Subject: COALESCE() and NULLIF() are now first-class expressions, not macros that turn into CASE expressions. They evaluate their arguments at most once. Patch by Kris Jurka, review and (very light) editorializing by me. --- doc/src/sgml/func.sgml | 13 +------------ 1 file changed, 1 insertion(+), 12 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index f2d84a969aa..fd247be28c2 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ @@ -6295,17 +6295,6 @@ SELECT NULLIF(value, '(none)') ... - - - COALESCE and NULLIF are - just shorthand for CASE expressions. They are actually - converted into CASE expressions at a very early stage - of processing, and subsequent processing thinks it is dealing with - CASE. Thus an incorrect COALESCE or - NULLIF usage may draw an error message that - refers to CASE. - - -- cgit v1.2.3