Received: from smtp011.mail.yahoo.com (smtp011.mail.yahoo.com
 [216.136.173.31])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f5SDLna15853
	for <pgsql-docs@postgresql.org>; Thu, 28 Jun 2001 09:21:49 -0400 (EDT)
	(envelope-from linuxero2@yahoo.com)
Received: from host002214.arnet.net.ar (HELO agarin) (200.45.2.214)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 28 Jun 2001 13:21:44 -0000
X-Apparently-From: <linuxero2@yahoo.com>
Message-ID: <00d301c0ff70$b44b7d00$3f40410a@agarin>
From: "Linuxero" <linuxero2@yahoo.com>
To: <pgsql-docs@postgresql.org>
References: <006401c0ff66$080164b0$3f40410a@agarin>
	<3B3B2646.7A108838@zhengmai.com.cn>
Subject: question about functions
Date: Wed, 27 Jun 2001 22:21:46 -0300
MIME-Version: 1.0
Content-Type: text/plain;
	charset="gb2312"
Content-Transfer-Encoding: 7bit
X-Priority: 1
X-MSMail-Priority: High
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Archive-Number: 200106/47
X-Sequence-Number: 845

Hi:

I'm interested in postgres because I want to use transactions
and store procedures (or functions).
I have created this table:
Table1
    c1 int4
    c2 varchar(5)

And this function

Name: Test
Return: setof int4
Language: sql

"select * from Table1";

But, this is not working because this funcion only return
a set of int4 results... I should replace this to 
"select c1 from Table1".

My question is:
How can i return a select with two o more colums? 
Like MS Sql server store procedures does.
Is it possible?

Thanks in advance.
Regards
---
EL Linuxero




_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com