| From: | max_conf(at)e-foto(dot)ru |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | returned multiple data from function |
| Date: | 2001-10-06 07:24:11 |
| Message-ID: | 115470664489.20011006112411@e-foto.ru |
| Views: | Whole Thread | Raw Message | 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. This indetification of objects.
or next 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Joerdens | 2001-10-06 15:33:22 | distance vector databases and country maps |
| Previous Message | Oleg Lebedev | 2001-10-05 23:54:11 | Re: Quotes and spaces |