2013/7/22 Dimitri Fontaine <dimi...@2ndquadrant.fr>: > 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… > $ TABLE top LIMIT 5; > > $ SET top.limit = 5; > $ TABLE top; >
It just not comfortable and it is not consistent with current psql commands design. In my proposal, you should to learn just char "s". I expect so every body knows "\dt" so \dts 10 compare with: $ TABLE top(5); -- needs a patch to accept SRF here… $ TABLE top LIMIT 5; Regards Pavel > Regards, > -- > Dimitri Fontaine > http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
