Re: SET within a function? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: SET within a function?
Date
Msg-id 20031014021752.GB32083@wolff.to
Whole thread Raw
In response to SET within a function?  (Edmund Dengler <edmundd@eSentire.com>)
Responses Re: SET within a function?  (Edmund Dengler <edmundd@eSentire.com>)
List pgsql-general
On Mon, Oct 13, 2003 at 21:16:33 -0400,
  Edmund Dengler <edmundd@eSentire.com> wrote:
>
> I think if I could do a 'SET TRANSFORM_NULL_EQUALS TO ON' then this might
> fix the issue (don't know, haven't tried it yet). My question is: can this
> be done within a function such that at the end of the function, the value
> is reset back to value upon entering (kind of like 'SET LOCAL' except for
> just the length of the function call). Is this possible?

I don't think that will do what you want. That setting is used to
rewrite = null as is null, not to change things so that nulls match each
other.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Index on timestamp to date field
Next
From: "Marc G. Fournier"
Date:
Subject: Re: gborg cvs ?