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

From Joe Conway
Subject Re: can Function return a row ???
Date
Msg-id 3CDF54AF.2090209@joeconway.com
Whole thread Raw
In response to can Function return a row ???  (Tahira Aslam <tahira_aslam@yahoo.com>)
Responses Re: can Function return a row ???
List pgsql-general
Tahira Aslam wrote:
> 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.
>

Sorry, but returning a composite (row) type does not work in 7.2.x or
before. It is being worked on now, and should be available in 7.3 when
it's released.

Joe




pgsql-general by date:

Previous
From: Tahira Aslam
Date:
Subject: can Function return a row ???
Next
From: Tahira Aslam
Date:
Subject: Re: can Function return a row ???