| 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: | Whole Thread | Raw Message | 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 |