Re: patch: autocomplete for functions

On Mon, Mar 19, 2012 at 1:01 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:

> I'm rather of the contrary opinion -- surely if we're going to complete
> function names, we should only complete those that are in schemas in the
> path; similarly for column names.

I think it makes sense to only include currently-visible functions,
but *not* only columns from currently visible tables, since we won't
know yet whether the user intends to schema-qualify the table name.

>  (BTW I didn't check but does this
> completion work if I schema-qualify a column name?)

Peter's proposed tab-completion only kicks in for the column-name
itself. Keep in mind, the user might be trying to enter: SELECT  schema.table.column ... SELECT  table.column ...
SELECT table_alias.column ... SELECT  column ... 

and presumably want to tab-complete the second token somehow. I'm a
bit leery about trying to tab-complete those first two, and the third
is right out. Just having the fourth would make me happy.

Josh