Re: SRF called with optional NULL input runs 7x slower

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(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 14:00:25
Message-ID: 20070924140025.GA5846@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ow Mun Heng wrote:
> On Mon, 2007-09-24 at 02:31 -0400, Alvaro Herrera wrote:

> > > 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?

I didn't say "pick a random datatype", I said "the correct type", which
in this case means the type "code" has in the function.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-09-24 14:58:54 Re: pg_dump problem: 'pg_dump: schema with OID 1515546 does not exist'
Previous Message Simon Riggs 2007-09-24 13:53:14 Re: Transaction Steps!!