quote_nullable alternative? - Mailing list pgsql-sql

From Philippe Lang
Subject quote_nullable alternative?
Date
Msg-id 6C0CF58A187DA5479245E0830AF84F4218CF6B@poweredge.attiksystem.ch
Whole thread Raw
List pgsql-sql
Hi,

There has been a recent discussion on the hacker mailing-list recently,
regarding a new patch for postgresql, that returns 'NULL' instead of
NULL when a NULL value is passed as a parameter.

It's exactly what I need on my 8.2.5 server.

Is there an alternative to patching the server in order to get that kind
of feature, for example with plpgsql code?

Because of that bug:

http://www.postgresql.org/docs/faqs.FAQ.html#item4.19

... I'm obliged to call EXECUTE at every temporary table call, and
constructing the query string where parameters can be NULL is really a
nightmare...

Thanks

Philippe Lang


pgsql-sql by date:

Previous
From: "Oliveiros Cristina"
Date:
Subject: Re: Obtaining the primary key of the record just inserted
Next
From: "Philippe Lang"
Date:
Subject: Re: quote_nullable alternative?