Home > mailing lists

[GENERAL] cursor declare - Mailing list pgsql-general

From	Peter Koukoulis
Subject	[GENERAL] cursor declare
Date	September 16, 2017 01:35:16
Msg-id	CABpxA9i-Qs8gnSjq4UEQDUUsYPiAxAzzfa2hwNBa1pCaFw3XSQ@mail.gmail.com Whole thread Raw
Responses	Re: [GENERAL] cursor declare (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

This is my first cursor attempt:

according to docs

DECLARE   curs1 refcursor;   curs2 CURSOR FOR SELECT * FROM tenk1;   curs3 CURSOR (key integer) FOR SELECT * FROM tenk1 WHERE unique1 = key;

this should work, but getting error:

ft_node=# declare cur_test1 CURSOR (key integer) for select * from test1 where x=key;

ERROR: syntax error at or near "("

LINE 1: declare cur_test1 CURSOR (key integer) for select * from tes...

Table is defined as:

psql (9.6.4)

SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)

Type "help" for help.

ft_node=# \d+ test1

Table "public.test1"

--------+-----------------------+-----------+----------+--------------+-------------

Can somebody please help?

From: Christopher Browne
Date: 16 September 2017, 01:30:28
Subject: Re: [GENERAL] looking for a globally unique row ID

From: Rafal Pietrak
Date: 16 September 2017, 01:39:24
Subject: Re: [GENERAL] looking for a globally unique row ID