Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E35CF63267B for ; Wed, 18 Aug 2010 11:45:32 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 53914-08 for ; Wed, 18 Aug 2010 14:45:25 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f46.google.com (mail-bw0-f46.google.com [209.85.214.46]) by mail.postgresql.org (Postfix) with ESMTP id 5FFF663243E for ; Wed, 18 Aug 2010 11:45:25 -0300 (ADT) Received: by bwz11 with SMTP id 11so256920bwz.19 for ; Wed, 18 Aug 2010 07:45:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:sender:subject:from:to:cc :in-reply-to:references:disposition-notification-to:content-type :date:message-id:mime-version:x-mailer:content-transfer-encoding; bh=x2LYBimSeTZiOMy6RdMKQInLvvaInXH57fM4FhzyKY4=; b=xSnPszyupsH2UYSDS31hZD3lFMhdtlkD4tCp+C3f6MWafsdGYK29ydJyOx6Nxe0isd 7zTyl/hPpbR4S0+jYpENeehcMaZv86OgnDmhRTrC1jKPIcDzWynC9anY2e9M2u22g4gy k1La2fV+Ex+CAZANh/j1rz8PE3JBnWzriGUpk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=sender:subject:from:to:cc:in-reply-to:references :disposition-notification-to:content-type:date:message-id :mime-version:x-mailer:content-transfer-encoding; b=ZBD9636X8NL68FfMhe/DjT0gocGaSo2PXMAg2I0gBsL+N2+LVhCXm7iL2O08tGx8Qa Mix3pjKXuyVcxRNFvmtgrwyidwmgb2bVgDb5UPP9jlajMrYeMKXhmHCuCPtoh4Y8YfKE 5IlyG0bc7tua+iQkrZDUNv2fsT7qNOdZlxcVA= Received: by 10.204.126.153 with SMTP id c25mr5400664bks.27.1282142723539; Wed, 18 Aug 2010 07:45:23 -0700 (PDT) Received: from [84.224.165.191] (netacc-gpn-4-165-191.pool.telenor.hu [84.224.165.191]) by mx.google.com with ESMTPS id bq20sm255828bkb.4.2010.08.18.07.45.20 (version=SSLv3 cipher=RC4-MD5); Wed, 18 Aug 2010 07:45:22 -0700 (PDT) Subject: Re: plpgsql out parameter with select into From: =?ISO-8859-1?Q?Horv=E1th?= Imre To: Sergey Konoplev Cc: pgsql-sql@postgresql.org In-Reply-To: References: <1282070709.3269.3.camel@cytherian.blemidon.dyndns.org> Content-Type: text/plain; charset="UTF-8" Date: Wed, 18 Aug 2010 16:45:17 +0200 Message-ID: <1282142717.2734.1.camel@cytherian.blemidon.dyndns.org> Mime-Version: 1.0 X-Mailer: Evolution 2.30.2 (2.30.2-4.fc13) Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201008/66 X-Sequence-Number: 34506 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 : > > 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 > > > > >