2013/2/14 Tom Lane <t...@sss.pgh.pa.us>: > Stephen Frost <sfr...@snowman.net> writes: >> * Pavel Stehule (pavel.steh...@gmail.com) wrote: >>> SELECT * FROM some_relation LIMIT 10 >>> >>> what do you thinking about creating special statement for this purpose? > >> I'd rather extend TABLE to support a limit clause or something. > > Can't you pretty much do this already in psql with FETCH_COUNT? I see > no good reason to invent more SQL syntax.
Doesn't that just split up the retrieval of the result set into blocks of FETCH_COUNT rows, i.e. does not limit the result set? Personally I set commonly-used queries as a psql variable, though what Pavel suggests sounds useful and AFAICT is not additional SQL syntax, just (yet another) psql slash command. Ian Barwick -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
