Обсуждение: Using cursors inside PL/pgSQL function

Поиск

Список

Период

Сортировка

Using cursors inside PL/pgSQL function

От

"Atul"

Дата:

23 апреля 2001 г., 03:30:27

Can't we use cursors inside pl/pgSQL functions. I tried defining the transaction with Begin work and end work statements, because the documentation says that cursors can only be defined in these blocks. But this does not work. I have the following code :

create function sample() returns text as '

declare

retValue text;

begin work

declare retCur Cursor for select * from <table name>;

Fetch 1 in retCur;

close retCur;

return ''abc'';

end work;'

language 'plpgsql';

When i execute the above it says ' parse error at or near "work" '. I know that in plpgsql function only begin and end keywords define the block, but since I need to retrieve the value one by one from the table I need to do this.

Is it possible to do the above? If yes, how can I return the value retrieved from the table, from the function?

Regards,

Atul

Re: Using cursors inside PL/pgSQL function

От

Ian Lance Taylor

Дата:

23 апреля 2001 г., 16:25:24

"Atul" <atulk@newgen.co.in> writes:

> Can't we use cursors inside pl/pgSQL functions.

No.

Here's a patch which supports most cases.

    http://www.airs.com/ian/pgsql-cursor.html

Ian

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Using cursors inside PL/pgSQL function

Using cursors inside PL/pgSQL function

Re: Using cursors inside PL/pgSQL function