Brendan Jurd wrote:
On Tue, Nov 11, 2008 at 2:36 AM, Ron Mayer I get the expected result from 'P0001', but oddly enough if I specify only the year and month, it pukes: postgres=# select interval 'P0001-01';
Indeed. Thanks again. I've fixed this and added regression tests to check the handling of optional fields of the "alternative format" which my patch has been so very bad at handling.
I'm attaching a patch to clean up a few more code style issues and fix broken spec references within C code comments in datetime.c.
Applied and pushed to the website http://0ape.com/postgres_interval_patches/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
