Re: Specific names for plpgsql variable-resolution control options? - Mailing list pgsql-hackers

From Sonu
Subject Re: Specific names for plpgsql variable-resolution control options?
Date
Msg-id efebab7d-352d-4429-8e4b-cf7779ddd680@a37g2000prf.googlegroups.com
Whole thread Raw
In response to Specific names for plpgsql variable-resolution control options?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Nov 7, 1:21 am, t...@sss.pgh.pa.us (Tom Lane) wrote:
> I believe we had consensus that plpgsql should offer the following three
> behaviors when a name in a SQL query could refer to either a plpgsql
> variable or a column from a table of the query:
>         * prefer the plpgsql variable (plpgsql's historical behavior)
>         * prefer the table column (Oracle-compatible)
>         * throw error for the ambiguity (to become the factory default)
> and that we wanted a way for users to select one of these behaviors at the
> per-function level, plus provide a SUSET GUC to determine the default
> behavior when there is not a specification in the function text.
>
> What we did not have was any concrete suggestions for the name or
> values of the GUC, nor for the exact per-function syntax beyond the
> thought that it could look something like the existing '#option dump'
> modifier.
>
> The code is now there and ready to go, so I need a decision on these
> user-visible names in order to proceed.  Anyone have ideas?
>
>                         regards, tom lane
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hack...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-hackers

I donot have  any further idea about the problem with th oracle
software but i do have a problem for you if you will help me out than
i will be thankful to you mr Tom lane actually i have downloaded a RAR
file type and also used an extracter software but even after
extracting the file it is not working properly will you tell me any
way by which i can apply and use the file on my lap


pgsql-hackers by date:

Previous
From: Jan Otto
Date:
Subject: Re: drop tablespace error: invalid argument
Next
From: Joshua Tolley
Date:
Subject: Re: plperl and inline functions -- first draft