X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 1351BDA589
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 19 Oct 2005 15:33:20 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 87151-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 19 Oct 2005 18:33:12 +0000 (GMT)
Received: from web8608.mail.in.yahoo.com (web8608.mail.in.yahoo.com
	[202.43.219.83])
	by svr1.postgresql.org (Postfix) with SMTP id 44652D6DAA
	for <pgsql-sql@postgresql.org>; Wed, 19 Oct 2005 15:33:11 -0300 (ADT)
Received: (qmail 92218 invoked by uid 60001); 19 Oct 2005 18:33:02 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=SbafFQ8erCTMJXLw3z5CpwEkq62Xvk2TbDKFlNSqQbcU0NVk6Vx8lYY9EgL2QSDGMOZX6XXff6ekkaMGIJ14Tzqn1KYQ1+p0V4LCR6tOFFWInkf+zb8IdWjNv20hH1YqnuBAfYoe3OrMyHd1zD6CuZZm2tTTtlQ37CNFL6ORl6g=
	;
Message-ID: <20051019183302.92216.qmail@web8608.mail.in.yahoo.com>
Received: from [12.109.150.2] by web8608.mail.in.yahoo.com via HTTP;
	Wed, 19 Oct 2005 19:33:02 BST
Date: Wed, 19 Oct 2005 19:33:02 +0100 (BST)
From: Muralidharan Ramakrishnan <contact2muraliin@yahoo.co.in>
Subject: Re: Problem -Postgre sql
To: Vikas J <vikas.jadhav@codecindia.com>, pgsql-sql@postgresql.org
In-Reply-To: <000c01c5ce34$61797c20$6f0aa8c0@codecindia.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-548338270-1129746782=:91787"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.415 required=5 tests=[AWL=-0.363,
	DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, HTML_60_70=0.027,
	HTML_MESSAGE=0.001]
X-Spam-Level: *
X-Archive-Number: 200510/223
X-Sequence-Number: 23076

--0-548338270-1129746782=:91787
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

COALESCE( <variable> , <default value>)
 


Vikas J <vikas.jadhav@codecindia.com> wrote:
Hi
I want to know substitute function for sql server ISNULL() function in postgre
 
Regards,

Vikas Jadhav 
Codec Communication Pvt. Ltd.
Swargate, Pune.
Ph: 020-2422 1460/70 (Ext 37)
Email: vikas.jadhav@codecindia.com


		
---------------------------------
 Yahoo! India Matrimony: Find your partner online.
--0-548338270-1129746782=:91787
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>COALESCE( &lt;variable&gt; , &lt;default value&gt;)</DIV>
<DIV>&nbsp;</DIV>
<DIV><BR><BR><B><I>Vikas J &lt;vikas.jadhav@codecindia.com&gt;</I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>

<DIV><FONT face=Arial size=2>Hi</FONT></DIV>
<DIV><FONT face=Arial size=2>I want to know substitute function for sql server ISNULL()&nbsp;function in postgre</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT color=blue name="verdana">Regards,<BR><BR>Vikas Jadhav <BR>Codec Communication Pvt. Ltd.<BR>Swargate, Pune.<BR>Ph: 020-2422 1460/70 (Ext 37)<BR>Email: <A href="mailto:vikas.jadhav@codecindia.com">vikas.jadhav@codecindia.com</A><BR></FONT></DIV></BLOCKQUOTE><p>
		<hr size=1> 
<a href=http://yahoo.shaadi.com>Yahoo! India Matrimony</a href>: Find your partner online.
--0-548338270-1129746782=:91787--