From: | David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com> |
---|---|
To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: psql wishlist: value completion |
Date: | 2004-08-14 09:01:39 |
Message-ID: | 411DD4F3.1010203@zara.6.isreserved.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Steve Crawford wrote:
>> # delete from person where firstname = 'D<tab><tab>
>> Display all 215 possibilities? (y or n)
>
> Sure it would be cool - but as far as I can tell totally impractical.
>
> Determining all the possible expandable values for a particular column
> could very well require a full-table-scan of a multi-million row
> table each time you try to tab-expand.
Well, psql could display "Warning: this would require a full-table-scan
of a multi-million row table..." or "Warning: there are more than 100
possibilities, continue?" if there are no indexes or the first SELECT
... LIMIT 101 returns 101 rows.
--
dave
From | Date | Subject | |
---|---|---|---|
Next Message | Geoff Caplan | 2004-08-14 09:13:04 | Re: Performance critical technical key |
Previous Message | Brendan Jurd | 2004-08-14 06:56:38 | Re: Autoincremental value |