Re: date formatting and tab-complete patch - Mailing list pgsql-hackers

Peter Eisentraut <peter_e@gmx.net> writes:

> Manuel Sugawara writes:
>
> > Guys, attached is a patch against the 7.2b3 source tree which improves
> > the i18n of the date formatting functions, using the nl_langinfo(3)
> > function,
>
> What's the effect of that?

Currently none since I miss another part of the patch :-( -attached-,
but if you add:

setlocale(LC_TIME, "");

in src/backend/main/main.c you will see month and day names printed
according to the current locale.

regress=#  select to_char(now(),'fmday dd/month/yyyy');
         to_char
--------------------------
 martes 04/diciembre/2001
(1 row)

> ISTM that in the situation that tab completion covers tables and views are
> not interchangeable.  Do you have an example?

select * from <TAB>
\d <TAB>

neither works for views; that's annoying, since most access to many
databases are done through views. Actually the only counterexamples I
found are DROP and ALTER TABLE but, may be, that's enough.

Regards,
Manuel.