Re: psql, tab completion additions

Patch applied to CVS HEAD only.  Thanks.

---------------------------------------------------------------------------


Sergey E. Koposov wrote:
>
> 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
>

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: 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

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073