can Function return a row ??? - Mailing list pgsql-general

From Tahira Aslam
Subject can Function return a row ???
Date
Msg-id 20020513053830.52185.qmail@web11008.mail.yahoo.com
Whole thread Raw
List pgsql-general

Dear postgresql Developers ..I need your help regarding postgresql funtion return type.I need to build a stored procedure like this

"Select First_Name,Last_Name,Designation,Department,Telephone_No,Fax_No From "Document""

But I can't get this whole row ...i can only extract single column like this

SELECT "First_Name"(STP_SelectAllFromdocument());

I am using postgresql 7.2 alongwith pgaccess.plz let me know how can i return a rowset from a function.

 



Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Chatter in C++ interface
Next
From: Joe Conway
Date:
Subject: Re: can Function return a row ???