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@sai.msu.ru
>
>

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