Re: [BUGS] BUG #6617: FETCH FIRST syntax accepts only constants and not parameters

2012-04-26 Thread Kevin Grittner
wrote: > 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) That's not a bug. Use the parentheses as specified in t

[BUGS] BUG #6617: FETCH FIRST syntax accepts only constants and not parameters

2012-04-26 Thread dodobas
The following bug has been logged on the website: Bug reference: 6617 Logged by: Dražen Odobašić Email address: dodo...@geoinfo.geof.hr PostgreSQL version: 9.1.3 Operating system: Linux 3.3.3 Description: When tried setting FETCH FIRST parameter dynamically in RETURN