parameterized fetch

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: parameterized fetch
Date: 2005-09-14 13:52:47
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD32B@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I've noticed that trying to parameterize a fetch statement via
ExecParams returns a syntax error:

fetch $1 from my_cursor;

This is not really a big deal, but maybe it should be documented which
statements can be parameterized and which can't (I take it that any
statement that can be prepared can be parameterized;

prepare test as fetch 1 from my_cursor;
also returns a syntax error;

Merlin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Pflug 2005-09-14 14:49:01 Re: 8.1 system info / admin functions
Previous Message Tom Lane 2005-09-14 13:48:19 Re: Bug with cursor declaration in plpgsql? (Repost)