Received: from mail.deltav.hu (mail.deltav.hu [213.163.0.192]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g03Fjem45182 for ; Thu, 3 Jan 2002 10:45:40 -0500 (EST) (envelope-from ltibor@mail.tiszanet.hu) Received: from pcltibor ([213.163.10.100]) by mail.deltav.hu (Netscape Messaging Server 3.6) with SMTP id AAA66CA; Thu, 3 Jan 2002 16:45:36 +0100 From: "Tibor Laszlo" To: "Karl Raven" , Subject: Re: change null to 0 in SQL script Date: Thu, 3 Jan 2002 16:45:38 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal In-Reply-To: X-Archive-Number: 200201/18 X-Sequence-Number: 6109 > I like to change a null value of a query to 0 The coalesce(something, 0) returns 0 if something is null, else returns something. Tibor Laszlo ltibor@mail.tiszanet.hu