On Mon, Jul 22, 2013 at 02:44:59PM -0700, Dimitri Fontaine wrote: > Pavel Stehule <pavel.steh...@gmail.com> writes: > >> SELECT * from top5(); > > $ TABLE top5; -- add a view on top of the SRF > > > you cannot use parameters - then I have to have prepared files like > > top10, top20, ... what is not too friendly > > The SRF could be using custom GUCs so that you can parametrize it, or > just even classic parametersā¦ > > $ TABLE top(5); -- needs a patch to accept SRF hereā¦
Andrew Gierth will probably be posting a design & patch for something similar soon :) Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers