How to return a record set from function.

Поиск

Список

Период

Сортировка

От	Kumar
Тема	How to return a record set from function.
Дата	27 августа 2003 г. 07:20:01
Msg-id	006901c36c6b$65ab2000$7502a8c0@hdsc.com обсуждение исходный текст
Ответы	Re: How to return a record set from function. Re: How to return a record set from function. Re: How to return a record set from function.
Список	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

В списке pgsql-sql по дате отправления:

От: Tom Lane
Дата: 27 августа 2003 г., 07:16:03
Сообщение: Re: postgres 7.1.3: why does the query plan ignore indexes?

От: Bruce Momjian
Дата: 27 августа 2003 г., 07:21:47
Сообщение: Re: postgres 7.1.3: why does the query plan ignore indexes?