Jyoti Seth wrote:
Hi,
I have a the following procedure
CREATE OR REPLACE FUNCTION getfunctionaries(p_statecd integer)
SELECT f.functionaryid, f.category,f.description
FROM functionaries f
where f.statecd=p_statecd
In the functionaries table statecd is a null field.
alue to the above procedure it works correctly but if I pass null value
> in
> p_statecd it doesn't show anything whereas it has values and if I write
> the
> select statement separately it gives values
>
> Thanks,
> Jyoti
>
> -Original Message-
> From: Richard Hux
@postgresql.org
Subject: Re: [SQL] postgresql function not accepting null values in select
statement
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'r
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
Hi,
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.
I have also changed the value of transform_null_equals = on in the conf file
and restarted postgresql. But it is still giving error.
Is t
