| From: | Thom Brown <thombrown(at)gmail(dot)com> | 
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | psql auto-completion for multiple where clauses | 
| Date: | 2010-07-16 14:42:55 | 
| Message-ID: | AANLkTinOdp9x0ac8NxuXayDwU4mbqFfInzXBTYkCAPbk@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
Someone highlighed on IRC that after the first WHERE clause,
autocomplete no longer works.
An example:
CREATE TABLE tab_completion (
id serial,
stuff text,
meow boolean
);
SELECT * FROM tab_completion WHERE id = 2 AND s<tab><tab>
This would output a blank line.
Is there any chance of improving this so it would work for more than 1
WHERE clause?  I notice it also doesn't work for GROUP BY or HAVING at
all, but seems to be fine for ORDER BY.
While we're at it, how about a smarter auto-complete for
quote-required column names (or whichever term I was supposed to use
just then):
CREATE TABLE tab_completion (
id serial,
stuff text,
"bark bark" boolean
);
SELECT * FROM tab_completion WHERE id = 2 AND b<tab>
Since there is no column beginning with "b", it might be an idea to
get it to match "bark bark" instead.  It might help alleviate what may
be a gotcha for some.
Thanks
Thom
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-07-16 14:43:16 | Re: dividing money by money | 
| Previous Message | Tom Lane | 2010-07-16 14:36:48 | Re: dividing money by money |