How to return a record set from function.

From: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>
To: "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: How to return a record set from function.
Date: 2003-08-27 07:18:15
Message-ID: 006901c36c6b$65ab2000$7502a8c0@hdsc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dear Friends,

I am newbie to Postgres. I am running 7.3.4 on Linux 7.3. I am using Pgadmin tool. I need to return the table rows via record set.

Create table t1 (c1 int, c2 varchar, c3 varchar);

Create or Replace function sel_t1 () returns setof records as '
select c1, c2, c3 from t1;
' Language SQL;

It was fine and created a function. while i execute it as

select sel_t1;

I got the following error.

ERROR: Cannot display a value of type RECORD

How to solve this. Please help.

Kumar

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message daq 2003-08-27 09:12:23 Canceling other backend's query
Previous Message Tom Lane 2003-08-27 04:27:20 Re: postgres 7.1.3: why does the query plan ignore indexes?