SQL funtion

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.

Browse pgsql-sql by date

  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