Re: [HACKERS] date/time improvements for 7.2

2001-10-18 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: > Are there places which decline to call a "normalization > routine" if typmod is less than zero, rather than equal to -1? The format_type routines think that typmod < 0 means "no typmod specified". I am not sure where else this may be true, but I'm pr

Re: [HACKERS] date/time improvements for 7.2

2001-10-18 Thread Thomas Lockhart
> > Implement precision for the INTERVAL() type. > > Use the typmod mechanism for both of INTERVAL features. > If I could figure out what the typmod of an interval type is defined > to be, I'd fix format_type() to display the type name properly so that > pg_dump would do the right thing. But it

Re: [HACKERS] date/time improvements for 7.2

2001-10-18 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: > Implement precision for the INTERVAL() type. > Use the typmod mechanism for both of INTERVAL features. If I could figure out what the typmod of an interval type is defined to be, I'd fix format_type() to display the type name properly so that pg_dump

[HACKERS] date/time improvements for 7.2

2001-10-18 Thread Thomas Lockhart
Accept an INTERVAL argument for SET TIME ZONE per SQL99. Modified the parser and the SET handlers to use full Node structures rather than simply a character string argument. I've implemented and committed changes to improve the feature set for INTERVAL, as well as making other bug fixes and impr