Re: small doc fix - using expressions in plpgsql FETCH command

2018-07-12 Thread Pavel Stehule
2018-07-12 18:29 GMT+02:00 Tom Lane : > Pavel Stehule writes: > > PLpgSQL FETCH documentation is has ref on SQL FETCH command. SQL FETCH > > allows only int constants as count. PLpgSQL allows any expressions. In > this > > case documentation is not clear, and people can be messy - and apply SQL >

Re: small doc fix - using expressions in plpgsql FETCH command

2018-07-12 Thread Tom Lane
Pavel Stehule writes: > PLpgSQL FETCH documentation is has ref on SQL FETCH command. SQL FETCH > allows only int constants as count. PLpgSQL allows any expressions. In this > case documentation is not clear, and people can be messy - and apply SQL > FETCH limits on PLpgSQL FETCH. Right. Pushed w

small doc fix - using expressions in plpgsql FETCH command

2018-07-06 Thread Pavel Stehule
Hi PLpgSQL FETCH documentation is has ref on SQL FETCH command. SQL FETCH allows only int constants as count. PLpgSQL allows any expressions. In this case documentation is not clear, and people can be messy - and apply SQL FETCH limits on PLpgSQL FETCH. https://stackoverflow.com/questions/5112933