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 9051BD97CD
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 18 Oct 2005 20:52:15 -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 37326-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 18 Oct 2005 23:52:12 +0000 (GMT)
Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158])
	by svr1.postgresql.org (Postfix) with ESMTP id B009CD6EB7
	for <pgsql-sql@postgresql.org>; Tue, 18 Oct 2005 20:52:13 -0300 (ADT)
Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1])
	by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j9INpZqE093583
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK);
	Tue, 18 Oct 2005 17:51:38 -0600 (MDT)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: from winnie.fuhr.org (localhost [127.0.0.1])
	by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id j9INpZDe044462;
	Tue, 18 Oct 2005 17:51:35 -0600 (MDT)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: (from mfuhr@localhost)
	by winnie.fuhr.org (8.13.4/8.13.4/Submit) id j9INpZhu044461;
	Tue, 18 Oct 2005 17:51:35 -0600 (MDT) (envelope-from mfuhr)
Date: Tue, 18 Oct 2005 17:51:35 -0600
From: Michael Fuhr <mike@fuhr.org>
To: Vikas J <vikas.jadhav@codecindia.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problem -Postgre sql
Message-ID: <20051018235135.GA44375@winnie.fuhr.org>
References: <000c01c5ce34$61797c20$6f0aa8c0@codecindia.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <000c01c5ce34$61797c20$6f0aa8c0@codecindia.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006]
X-Spam-Level: 
X-Archive-Number: 200510/205
X-Sequence-Number: 23058

On Tue, Oct 11, 2005 at 12:50:49PM +0530, Vikas J wrote:
> I want to know substitute function for sql server ISNULL() function in postgre

If you look in the index of the PostgreSQL documentation you'll
find an entry for ISNULL:

http://www.postgresql.org/docs/8.0/interactive/bookindex.html

If PostgreSQL's ISNULL doesn't do what you want then please explain
what you're trying to do.  Many people on these lists don't use SQL
Server so they don't know its ISNULL works.

(BTW, it's PostgreSQL or Postgres, not Postgre.)

-- 
Michael Fuhr