From: | Kristo Kaiv <kristo(dot)kaiv(at)skype(dot)net> |
---|---|
To: | Kristo Kaiv <kristo(dot)kaiv(at)skype(dot)net> |
Cc: | Postgresql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: table column vs. out param [1:0] |
Date: | 2007-08-23 08:16:33 |
Message-ID: | 215F570E-5A23-47D5-AE37-081EE755897E@skype.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
On 23.08.2007, at 11:11, Kristo Kaiv wrote:
>
> On 23.08.2007, at 8:51, Kristo Kaiv wrote:
>
>> I am trying to implement the new out parameters in functions and
>> stumbled upon a problem.
>> There is an internal requirement for our databases that every
>> function call always returns 2 params status & status_text.
>> The problem now is that plpgsql selects the out params themselves
>> into out params instead of function call results that i need there.
>> If this is the expected behavior of out params it makes using out
>> params a bit complicated if some table attributes
>> happen to have the same name as out params. How can i overcome
>> this situation? I can understand function variables having precedence
>> over column names as you can freely rename them but out params is
>> a different situation.
>>
>> snippet from code
>> -[cut]--
>>
>> out status int, -- 200
>> out status_text text -- OK
>> ) AS $$
>> BEGIN
>>
>> -[cut]--
>> SELECT status, status_text
>> FROM service._simple_add(
>> i_key_user
>> ,i_key_service
>> ,i_action
>> ,i_subscr_len)
>> INTO status, status_text;
>> -[cut]-
>
> using a table (function) alias seems to solve the problem.
>
then again select "status", "status_text" takes the variable again?
why is that?
this kind of behaviour seems kind of bizarre to me.
Kristo Kaiv
http://kaiv.wordpress.com (PostgreSQL blog)
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2007-08-23 08:23:04 | Re: Converting non-null unique idx to pkey |
Previous Message | Kristo Kaiv | 2007-08-23 08:11:57 | Re: table column vs. out param [1:0] |
From | Date | Subject | |
---|---|---|---|
Next Message | RPK | 2007-08-24 10:42:55 | SQL query to display like this |
Previous Message | Kristo Kaiv | 2007-08-23 08:11:57 | Re: table column vs. out param [1:0] |