Re: Operations widh CURSORS

Marcos Barreto de Castro <mbdecastro(at)yahoo(dot)com> writes:
> I am issuing a "BEGIN WORK" statement, after that I
> am issuing "DECLARE c_cursor FOR SELECT * FROM table".
> When, after that, I issue "DECLARE c_cursor1 FOR
> SELECT COUNT(*) FROM table" I get a segmentation
> fault.

Seems to work fine for me ... what version are you using?

regards, tom lane

regression=# create table foo(f1 int);
CREATE
regression=# insert into foo values(1);
INSERT 277673 1
regression=# insert into foo values(2);
INSERT 277674 1
regression=# insert into foo values(3);
INSERT 277675 1
regression=# insert into foo values(4);
INSERT 277676 1
regression=# begin;
BEGIN
regression=# DECLARE c_cursor CURSOR FOR SELECT * FROM foo;
SELECT
regression=# DECLARE c_cursor1 CURSOR FOR SELECT count(*) FROM foo;
SELECT
regression=# fetch 1 from c_cursor;
f1
----
1
(1 row)

regression=# fetch 1 from c_cursor1;
count
-------
4
(1 row)

regression=# fetch 1 from c_cursor;
f1
----
2
(1 row)

regression=# fetch 1 from c_cursor;
f1
----
3
(1 row)

regression=# fetch 1 from c_cursor;
f1
----
4
(1 row)

regression=# fetch 1 from c_cursor1;
count
-------
(0 rows)

regression=# fetch 1 from c_cursor;
f1
----
(0 rows)

regression=# end;
COMMIT