Received: from chac.qld.edu.au (linux.chac.qld.edu.au [203.37.221.131] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id UAA30785 for ; Thu, 30 Mar 2000 20:10:20 -0500 (EST) (envelope-from jhunt@chac.qld.edu.au) Received: from chac.qld.edu.au (chac.inet [203.37.221.129]) by chac.qld.edu.au (8.9.3/8.9.3) with ESMTP id LAA33208; Fri, 31 Mar 2000 11:02:40 +1000 (EST) (envelope-from jhunt@chac.qld.edu.au) Message-ID: <38E3FB11.DF2AACE0@chac.qld.edu.au> Date: Fri, 31 Mar 2000 11:10:42 +1000 From: Julie Hunt Reply-To: jhunt@chac.qld.edu.au Organization: Cannon Hill Anglican College X-Mailer: Mozilla 4.61 (Macintosh; I; PPC) X-Accept-Language: en MIME-Version: 1.0 To: Joseph Shraibman CC: "pgsql-sql@postgresql.org" Subject: Re: isnull References: <004701bf9901$c2b322c0$9714a8c0@julies> <38E3D461.E80EB898@selectacast.net> <38E3DC17.3F1A865@chac.qld.edu.au> <38E3DE24.72ACFA25@selectacast.net> Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F5353" Content-Transfer-Encoding: 7bit X-Archive-Number: 200003/10 Could you describe exactly what you are trying to achieve and the select statement with the case you tried. Joseph Shraibman wrote: > > > I've actually taken a closer look at the web page and not only did the name change, > but I now notice that they change what it is supposed to do as well. It does work > as currently defined, but I needed something that does what the original > documentation said: > > IFNULL(input,non-NULL substitute) > return second argument if first is NULL > Example: IFNULL(c1, 'N/A')