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:11:57 |
Message-ID: | 48E7152F-8921-431A-86CF-D03032EAC940@skype.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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.
Kristo Kaiv
http://kaiv.wordpress.com (PostgreSQL blog)
From | Date | Subject | |
---|---|---|---|
Next Message | Kristo Kaiv | 2007-08-23 08:16:33 | Re: table column vs. out param [1:0] |
Previous Message | Lange Marcus | 2007-08-23 07:55:28 | Local authentication/security |
From | Date | Subject | |
---|---|---|---|
Next Message | Kristo Kaiv | 2007-08-23 08:16:33 | Re: table column vs. out param [1:0] |
Previous Message | Kristo Kaiv | 2007-08-23 05:51:36 | table column vs. out param [1:0] |