Re: Specific names for plpgsql variable-resolution control options?
От | Sonu |
---|---|
Тема | Re: Specific names for plpgsql variable-resolution control options? |
Дата | |
Msg-id | efebab7d-352d-4429-8e4b-cf7779ddd680@a37g2000prf.googlegroups.com обсуждение исходный текст |
Ответ на | Specific names for plpgsql variable-resolution control options? (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | 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 по дате отправления: