Re: Pgsql dynamic statements and null values - Mailing list pgsql-general

From Ragnar Hafstað
Subject Re: Pgsql dynamic statements and null values
Date
Msg-id 1110357113.12057.0.camel@localhost.localdomain
Whole thread Raw
In response to Pgsql dynamic statements and null values  ("Guy Rouillier" <guyr@masergy.com>)
List pgsql-general
On Tue, 2005-03-08 at 16:30 -0600, Guy Rouillier wrote:
> We use a dynamic statement in a pgsql stored function to insert rows
> into a table determined at run time.  After much debugging, I've
> discovered that a null incoming argument will cause the dynamic
> statement to evaluate to null.  The error message emitted is "unable to
> execute null statement."

can't you use COALESCE() ?

gnari



pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Can't delete - Need cascading update instead
Next
From: Marco Colombo
Date:
Subject: Re: postgresql vs mysql performance comparison