Re: [ok] Re: psql wishlist: value completion - Mailing list pgsql-general

From j0rd1 adame
Subject Re: [ok] Re: psql wishlist: value completion
Date
Msg-id 200408131755.43549.jordi@jordi.net
Whole thread Raw
In response to Re: psql wishlist: value completion  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

El Vie 13 Ago 2004 16:27, Steve Crawford escribió:
> On Friday 13 August 2004 12:18 pm, David Garamond wrote:
> > Wouldn't it be cool if someday psql could do value completion?
> >
> >   # delete from person where lastname = 'Garam<tab>
> >   # delete from person where lastname = 'Garamond' _
> >
> >   # delete from person where firstname = 'Da<tab><tab>
> >   # delete from person where firstname = 'Da
> >   Damian  Darren  Dave    David    Dawson
> >
> >   # 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. Not only would performance be
> terrible but get a few users doing this and you could really hammer
> the server.

This could be an extra cool-hack and not nesesarely be part of the core
distribution.

greets

j0rd1
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBHUbuB5QJme5SU08RAhp4AJ433eG+glvfarErjdsWLXGZd1joxACdGPhr
l1TsTGx7ARJNCNen7sObTo4=
=rpFy
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Tom Allison
Date:
Subject: Re: PostgreSQL 8.0 Feature List?
Next
From: Gaetano Mendola
Date:
Subject: Re: Postgres 8.0 -> BEGIN EXCEPTION END Syntax????