| From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | ML PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SRF called with optional NULL input runs 7x slower |
| Date: | 2007-09-24 06:53:49 |
| Message-ID: | 1190616829.17050.59.camel@neuromancer.home.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2007-09-24 at 02:31 -0400, Alvaro Herrera wrote:
> Ow Mun Heng wrote:
>
> > Okay.. I tried that, but it seems like there's an issue w/ the CASE
> > statements.
> >
> > When I tried the prepare w/
> >
> > AND (CASE WHEN $3 IS NULL THEN true else d.code = any ($3) END)
> > AND (CASE WHEN $4 IS NULL THEN TRUE else D.id = any($4) END)
> >
> >
> > it ERRORs w/ could not determine data type of parameter $3
>
> Cast it to the correct type.
how do I cast a NULL? Is it Varchar?
Anyway.. I tried
AND (CASE WHEN CAST($3 as VARCHAR) IS NULL THEN true else d.code = any
($3) END)
and I get ERROR: op ANY/ALL (array) requires array on right side
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anoo Sivadasan Pillai | 2007-09-24 07:20:22 | Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug? |
| Previous Message | Alvaro Herrera | 2007-09-24 06:31:48 | Re: SRF called with optional NULL input runs 7x slower |