Re: proposal or just idea for psql - show first N rows from relation backslash statement

On Thu, Feb 14, 2013 at 10:32 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> 2013/2/14 Stephen Frost <sfrost@snowman.net>:
>> * Pavel Stehule (pavel.stehule@gmail.com) wrote:
>>> it is not true
>>
>> It most certainly is true- did you look at the command?
>>
>> SELECT top10('foo');
>>
>> Note that it's "top10", implying that it'd return the first 10 records.
>> That's only 2 characters more than:
>
> In current implementation you need a a polymorphic function
>
> and then you have to write
>
> SELECT (top10('foo')).*
>
> or
>
> SELECT * FROM top10('foo')

that can't work either -- at least not without a column select list.
there has to be some clue to output time from arguments to the
function.

merlin