Hello! I'm connecting via libpq and want to use prepared statements in a cursor. Is there a sample somewhere, since I cannot get it to work. sebjlun=# \d ssignal Table "public.ssignal" Column | Type | Modifiers ---------+---------------+----------- ssignam | character(12) | not null ssigdes | character(30) | not null ssopcid | character(40) | sstatyp | integer | not null sstatid | integer | not null ssigtyp | integer | not null ssigadd | integer | not null ssigran | integer | not null Indexes: "ssignalp1" PRIMARY KEY, btree (ssignam) "ssignali3" btree (sstatyp, sstatid) sebjlun=# prepare test as sebjlun-# select * from SSIGNAL where SSTATYP=$1 and SSTATID=$2 order by SSIGNAM sebjlun-# ; PREPARE sebjlun=# execute test(4,6); ssignam | ssigdes | ssopcid | sstatyp | sstatid | ssigtyp | ssigadd | ssigran --------------+--------------------------------+-------------------------------- ----------+---------+---------+---------+---------+--------- CD_PLC_SS | Counter delay output PLC | | 4 | 6 | 2 | 2103 | 16 CD_SS_PLC | Counter delay input SS | | 4 | 6 | 2 | 2003 | 16 CN_PLC_SS | Counter number output PLC | | 4 | 6 | 2 | 2102 | 16 CN_SS_PLC | Counter Number input SS | | 4 | 6 | 2 | 2002 | 16 .... so far so good sebjlun=# declare cursor ctest for test(4,6); ERROR: syntax error at or near "ctest" LINE 1: declare cursor ctest for test(4,6); ^ sebjlun=# How would I express that? Combining cursors with parameter seems not to be the way either sebjlun=# Declare C240 cursor for select * from SSIGNAL where SSTATYP=$1 and SSTATID=$2 order by SSIGNAM; ERROR: there is no parameter $1 sebjlun=# /Björn |
