Re: psql, tab completion additions

Now the patch have been made using "cvs diff -c"

Sergey

On Tue, 29 Nov 2005, Sergey E. Koposov wrote:

> Hello All,
>
> 1) I'm proposing a patch to do the DROP FUNCTION argument tab completion.
> Now, the arguments of the drop function can be tab completed. for example
>
> drop function strpos (
> <press tab>
> drop FUNCTION strpos (text, text)
>
> or:
>
> wsdb=# drop FUNCTION length (
> bit) bytea) character) lseg) path) text)
> <press c>
> wsdb# DROP FUNCTION length ( character)
>
> I think that this patch should be rather useful. At it least I hate
> always to type all the arguments of the dropped functions.
>
> 2) Also some fixes applied for the
> CREATE INDEX syntax
>
> now the parenthesises are inserted by tab pressing.
> suppose I have the table q3c:
> wsdb=# \d q3c
> Table "public.q3c"
> Column | Type | Modifiers
> --------+------------------+-----------
> ipix | bigint |
> ra | double precision |
> dec | double precision |
>
> Now if I do
> wsdb# create index xxx on q3c
> <press tab>
> wsdb# CREATE INDEX xxx on q3c (
> <press tab>
> wsdb=# CREATE INDEX xxx on q3c (
> "dec" ipix ra
> <press r>
> wsdb=# CREATE INDEX xxx on q3c ( ra
>
> Regards,
> Sergey
>
> *****************************************************
> Sergey E. Koposov
> Max-Planck Institut for Astronomy
> Web: http://lnfm1.sai.msu.ru/~math
> E-mail: math(at)sai(dot)msu(dot)ru
>
>

*****************************************************
Sergey E. Koposov
Max-Planck Institut for Astronomy
Web: http://lnfm1.sai.msu.ru/~math
E-mail: math(at)sai(dot)msu(dot)ru