Re: psql wishlist: value completion

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