Received: from lin.local.lan ([216.221.221.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0CHYDp63789 for ; Fri, 12 Jan 2001 12:34:13 -0500 (EST) (envelope-from najm@mondo-live.com) Received: from mondo-live.com (IDENT:najm@ll20.local2.lan [192.168.2.20]) by lin.local.lan (8.9.3/8.8.7) with ESMTP id QAA21619 for ; Fri, 12 Jan 2001 16:17:47 GMT Message-ID: <3A6092CA.1413C4E7@mondo-live.com> Date: Sat, 13 Jan 2001 12:39:22 -0500 From: Najm Hashmi X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: SQL funtion Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/121 X-Sequence-Number: 782 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.