Re: postgresql function not accepting null values in select statement

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jyoti Seth <jyotiseth2001(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: postgresql function not accepting null values in select statement
Date: 2008-02-22 09:05:28
Message-ID: 47BE9058.9030909@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jyoti Seth wrote:
>
> If I pass null value as the parameter of postgresql function, which is used
> in the where clause of select statement is not functioning properly.

Either:

1. You're talking about frooble(), in which case it's supposed to do that.

or

2. You'll need to tell us what function it is, how you're using it and
what you think should happen.

My guess is that you're getting a null as the result and that's not
doing what you'd expect in your where clause.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jyoti Seth 2008-02-22 09:22:55 Re: postgresql function not accepting null values in select statement
Previous Message Jyoti Seth 2008-02-22 08:30:42 postgresql function not accepting null values in select statement