Re: SET within a function?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Edmund Dengler <edmundd(at)eSentire(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SET within a function?
Date: 2003-10-14 02:17:52
Message-ID: 20031014021752.GB32083@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 13, 2003 at 21:16:33 -0400,
Edmund Dengler <edmundd(at)eSentire(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edmund Dengler 2003-10-14 02:49:28 Re: SET within a function?
Previous Message Marc G. Fournier 2003-10-14 02:14:11 Re: gborg cvs ?