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

From Merlin Moncure
Subject Re: proposal or just idea for psql - show first N rows from relation backslash statement
Date
Msg-id CAHyXU0xWb9xK3Bs_AnpVYuB7z+dvkon-VPBmVz6ehooSY4yJuA@mail.gmail.com
Whole thread Raw
In response to Re: proposal or just idea for psql - show first N rows from relation backslash statement  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Manlio Perillo
Date:
Subject: Re: [RFC] ideas for a new Python DBAPI driver (was Re: libpq test suite)
Next
From: Merlin Moncure
Date:
Subject: Re: proposal or just idea for psql - show first N rows from relation backslash statement