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)

--
dave


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

On Friday 13 August 2004 12:18 pm, David Garamond wrote:[color=blue]
> 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)[/color]

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.

Cheers,
Steve


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Steve Crawford wrote:
[color=blue]
> On Friday 13 August 2004 12:18 pm, David Garamond wrote:
>[color=green]
>>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)[/color]
>
>
> 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.[/color]

Why you need a full-table-scan ? The search will be an anchored search and
with the right operator class a index scan can occur.
However I have do admit that is nice but impratical.



Regards
Gaetano Mendola

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

El Vie 13 Ago 2004 16:27, Steve Crawford escribió:[color=blue]
> On Friday 13 August 2004 12:18 pm, David Garamond wrote:[color=green]
> > 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)[/color]
>
> 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.[/color]

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+glvfarErjdsWLX GZd1joxACdGPhr
l1TsTGx7ARJNCNen7sObTo4=
=rpFy
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Steve Crawford wrote:[color=blue][color=green]
>> # delete from person where firstname = 'D<tab><tab>
>> Display all 215 possibilities? (y or n)[/color]
>
> 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.[/color]

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)