2009/8/11 Pavel Stehule <pavel.steh...@gmail.com>: > It's nice. I am playing with it, and now I found some potential issue. > The parser is maybe too tolerant: > > postgres=# select to_char(3.14323,'9.9(aaaaaEEEE'); > to_char > ---------- > 3.1e+00 > (1 row) >
I guess we *could* add code to throw an error where the 9's aren't placed immediately before the E's in the format pattern, but to be honest I can't work up any enthusiasm about it. Cheers, BJ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers