From: | Najm Hashmi <najm(at)mondo-live(dot)com> |
---|---|
To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | SQL funtion |
Date: | 2001-01-13 17:39:22 |
Message-ID: | 3A6092CA.1413C4E7@mondo-live.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi All,
I have written a very simply function as follows:
create function song_info(int4) returns setof songs as'
select songs.* from songs
where $1=song_id'
language 'sql';
when iIcall it I get the following: flipr=# select song_info(4);
?column?
-----------
136428992
(1 row)
Is not it suppose to retrun me the tuple form songs table rather than
oid....
If I want to get a complete tuple what can I do.
Thank you all for your help.
Regards, Najm.
From | Date | Subject | |
---|---|---|---|
Next Message | Najm Hashmi | 2001-01-13 17:59:09 | pl/pgsql Limits |
Previous Message | Tom Lane | 2001-01-13 17:31:21 | Re: pl/pgsql Limits |