Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 1EBDE476879
	for <pgsql-sql@postgresql.org>; Thu, 12 Dec 2002 09:49:55 -0500 (EST)
Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66])
	by postgresql.org (Postfix) with ESMTP id D76CD4762C6
	for <pgsql-sql@postgresql.org>; Thu, 12 Dec 2002 09:49:19 -0500 (EST)
Received: from klaster.net (pb73.krakow.cvx.ppp.tpnet.pl [213.76.37.73])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id 16E762B266; Thu, 12 Dec 2002 15:34:05 +0100 (CET)
Message-ID: <3DF8A280.1010107@klaster.net>
Date: Thu, 12 Dec 2002 15:51:44 +0100
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US;
	rv:1.2b) Gecko/20021016
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Atul <atul@imcindia.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Stored Procedure Problem
References: <LHEOILFLDANINFJAGPEOIEFNCAAA.atul@imcindia.net>
In-Reply-To: <LHEOILFLDANINFJAGPEOIEFNCAAA.atul@imcindia.net>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/159
X-Sequence-Number: 10747

Atul wrote:

> CREATE FUNCTION b_function() RETURNS varchar AS '
>
>  DECLARE
>
>     an_integer int4;
>
>     an_name    varchar;
>
>  BEGIN
>
>     select into an_integer emp_id,an_name emp_name from employee;
>
>     return an_integer,an_name;
>
>  END;
>
>  '

First: select into an_integer,an_name emp_id,emp_name...
Second: you can't return 2 variables from plpgsql function.

Tomasz Myrta