From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, fabriziomello(at)gmail(dot)com, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: proposal or just idea for psql - show first N rows from relation backslash statement |
Date: | 2013-02-14 17:44:33 |
Message-ID: | CAHyXU0xWb9xK3Bs_AnpVYuB7z+dvkon-VPBmVz6ehooSY4yJuA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Feb 14, 2013 at 10:32 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> 2013/2/14 Stephen Frost <sfrost(at)snowman(dot)net>:
>> * Pavel Stehule (pavel(dot)stehule(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2013-02-14 17:45:43 | Re: proposal or just idea for psql - show first N rows from relation backslash statement |
Previous Message | Manlio Perillo | 2013-02-14 17:40:21 | Re: [RFC] ideas for a new Python DBAPI driver (was Re: libpq test suite) |