Skip site navigation (1) Skip section navigation (2)

BUG #6617: FETCH FIRST syntax accepts only constants and notparameters

From: dodobas(at)geoinfo(dot)geof(dot)hr
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6617: FETCH FIRST syntax accepts only constants and notparameters
Date: 2012-04-26 16:02:21
Message-ID: E1SNR9B-0001iZ-OE@wrigleys.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6617
Logged by:          Dražen Odobašić
Email address:      dodobas(at)geoinfo(dot)geof(dot)hr
PostgreSQL version: 9.1.3
Operating system:   Linux 3.3.3
Description:        

When tried setting FETCH FIRST parameter dynamically in RETURN QUERY EXECUTE
some_query USING param1 it resulted with a syntax error on FETCH FIRST
parameter.

Apparently, it only accepts constants so it works with ($1) 

Bug example: https://pgsql.privatepaste.com/1e3ef786a5


Responses

pgsql-bugs by date

Next:From: Kevin GrittnerDate: 2012-04-26 16:52:06
Subject: Re: BUG #6617: FETCH FIRST syntax accepts only constants and not parameters
Previous:From: Ryan KellyDate: 2012-04-26 11:42:32
Subject: ALTER TABLE ... OWNER TO does not change ownership recursively

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group