Re: can Function return a row ???

From: Tahira Aslam <tahira_aslam(at)yahoo(dot)com>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: can Function return a row ???
Date: 2002-05-13 06:29:47
Message-ID: 20020513062947.57045.qmail@web11008.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Thanks Joe for your timly help..but still i have a little confusion.I read postgresql 7.2 Documentation for PL/pgsql (chapter 23)...its about "Cursors" but it says something like this also
"A more interesting possibility is that a function can return a reference to a cursor it has set up,allowing the caller to read the rows. This provides one way of returning a rowset from a function"
plz I need further guidance in this regard..
Thanks
Tahira Aslam
Joe Conway <mail(at)joeconway(dot)com> wrote: 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Michel POURE 2002-05-13 13:22:29 Re: Database encoding
Previous Message Joe Conway 2002-05-13 05:52:47 Re: can Function return a row ???