From: Sergey Konoplev <gray.ru@gmail.com>
To: Horváth Imre <horvath.imre@blemidon.hu>
Cc: pgsql-sql@postgresql.org
Subject: Re: plpgsql out parameter with select into
Date: Thu, 19 Aug 2010 01:58:14 +0400
Message-ID: <AANLkTi=F46H7BqASW4dLGGx3yn0nL95dES8UKbaeyudb@mail.gmail.com> (raw)
In-Reply-To: <1282142717.2734.1.camel@cytherian.blemidon.dyndns.org>
References: <1282070709.3269.3.camel@cytherian.blemidon.dyndns.org>
<AANLkTi=YT1cYTeu0JbN_0ZYBjN-jyrA6fpRDuQcX95xN@mail.gmail.com>
<1282142717.2734.1.camel@cytherian.blemidon.dyndns.org>
What is your PG version?
2010/8/18 Horváth Imre <horvath.imre@blemidon.hu>:
> It don't work...
>
> Only select into status * from... works.
>
> Imre Horvath
>
> 2010. 08. 18, szerda keltezéssel 09.42-kor Sergey Konoplev ezt írta:
>> Hi,
>>
>> SELECT column_name
>> INTO var_name
>> FROM ...
>>
>> 2010/8/17 Horváth Imre <horvath.imre@blemidon.hu>:
>> > Hi!
>> >
>> > My question is, how can I get the out parameter from a function with
>> > SELECT INTO by name?
>> > I mean:
>> >
>> > create function testfunc1(OUT _status integer) returns integer as
>> > $BODY$
>> > _status := 0;
>> > $BODY$
>> > language plpgsql;
>> >
>> > create function testfunc2() as
>> > declare
>> > status integer;
>> > $BODY$
>> > select into status * from testfunc1();
>> > $BODY$
>> > language plpgsql;
>> >
>> > create function testfunc3() as
>> > declare
>> > status integer;
>> > $BODY$
>> > select into status _status from testfunc1();
>> > $BODY$
>> > language plpgsql;
>> >
>> > testfunc2 works, testfunc3 not.
>> >
>> > Thanks in advance:
>> > Imre Horvath
>> >
>> >
>> > --
>> > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
>> > To make changes to your subscription:
>> > http://www.postgresql.org/mailpref/pgsql-sql
>> >
>>
>>
>>
>
>
>
--
Sergey Konoplev
Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gray.ru@gmail.com, horvath.imre@blemidon.hu
Subject: Re: plpgsql out parameter with select into
In-Reply-To: <AANLkTi=F46H7BqASW4dLGGx3yn0nL95dES8UKbaeyudb@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox