returned multiple data from function

From: Maxim <max_conf(at)e-foto(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: returned multiple data from function
Date: 2001-10-03 11:51:05
Message-ID: 9peu39$13b0$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

Example:

select function getmylogs (inet) returns set of mylogs
as 'select mylogs.* from mylogs
where $1 = mylogs.local_ip'
language 'sql';

Returns:

?column?
--------
136538048
136538048
136538048
136538048
136538048
136538048
136538048

etc.

It not the table from database.

or nex example:

create function gelinvoice (int4) returns ?__?
as ' SELECT Invoice.Num, Invoice.Date, Buyer.Name
FROM Invoice, Buyer
WHERE Invoice.BuyerID=Buyer.ID AND Buyer.Num-$1
ORDER BY Buyer.Name'
Language 'sql';

What in that case it is necessary to write in ?__? ?
Or if it is necessary to return result of select of the temporary table?

Maxim.
http://virus.e-foto.ru

Browse pgsql-general by date

  From Date Subject
Next Message Neal Lindsay 2001-10-03 12:52:49 Sub-select testing group membership (Arrays)
Previous Message Pedro Alves 2001-10-03 10:34:33 Re: Perl and PostgreSQL 7.1.2 a DBI Connection