[HACKERS] Re: v7.1.1 branched and released on Tuesday ...
Nothing serious, but I would like to apply a patch to allow IDENT strings (e.g. 'hour') to be accepted by the SQL92 EXTRACT() function. We accept those for date_part(), which is what EXTRACT() is translated to by the parser, and it seems to be a reasonable to the standard. But why does that need to go into 7.1.1? Does not need to. But it is non-invasive, extremely low risk, gets the behavior to match the docs, and gets it off my desk and into the main tree. - Thomas ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] Re: v7.1.1 branched and released on Tuesday ...
Thomas Lockhart writes: Nothing serious, but I would like to apply a patch to allow IDENT strings (e.g. 'hour') to be accepted by the SQL92 EXTRACT() function. We accept those for date_part(), which is what EXTRACT() is translated to by the parser, and it seems to be a reasonable to the standard. But why does that need to go into 7.1.1? Does not need to. But it is non-invasive, extremely low risk, gets the behavior to match the docs, and gets it off my desk and into the main tree. Hehe, match the docs? The docs used to be perfectly accurate until you changed them. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Re: v7.1.1 branched and released on Tuesday ...
Thomas Lockhart [EMAIL PROTECTED] writes: Nothing serious, but I would like to apply a patch to allow IDENT strings (e.g. 'hour') to be accepted by the SQL92 EXTRACT() function. We accept those for date_part(), which is what EXTRACT() is translated to by the parser, and it seems to be a reasonable to the standard. But why does that need to go into 7.1.1? Does not need to. But it is non-invasive, extremely low risk, gets the behavior to match the docs, and gets it off my desk and into the main tree. If the current behavior does not match the docs then it qualifies as a bug fix ;-). I have no objections to this one. Thomas, what do you think of the persistent reports of date conversion problems at DST boundaries, eg, Ayal Leibowitz's report today in pgsql-bugs? I cannot reproduce any such problem --- and my local timezone database claims that MET DST transitions are the last week of March, never the first week of April, anyway. There's something funny going on there. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Re: v7.1.1 branched and released on Tuesday ...
Thomas, what do you think of the persistent reports of date conversion problems at DST boundaries, eg, Ayal Leibowitz's report today in pgsql-bugs? I cannot reproduce any such problem --- and my local timezone database claims that MET DST transitions are the last week of March, never the first week of April, anyway. There's something funny going on there. Yes. I tried the example on 7.0.2 (and 7.1) and could not get it to misbehave. I was guessing that it involves string-date conversion, which may pass through timestamp to get there, but it looks like there is an explicit text-date conversion function so time zone should just never be involved. Really! - Thomas ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Re: v7.1.1 branched and released on Tuesday ...
Hehe, match the docs? The docs used to be perfectly accurate until you changed them. ;) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Re: v7.1.1 branched and released on Tuesday ...
Nothing serious, but I would like to apply a patch to allow IDENT strings (e.g. 'hour') to be accepted by the SQL92 EXTRACT() function. We accept those for date_part(), which is what EXTRACT() is translated to by the parser, and it seems to be a reasonable to the standard. ... reasonable *extension* to the standard. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] Re: v7.1.1 branched and released on Tuesday ...
Does anyone have any outstanding fixes for v7.1.x that they want to see in *before* we do this release? Any points unresolved that anyone knows about that we need to look at? Nothing serious, but I would like to apply a patch to allow IDENT strings (e.g. 'hour') to be accepted by the SQL92 EXTRACT() function. We accept those for date_part(), which is what EXTRACT() is translated to by the parser, and it seems to be a reasonable to the standard. - Thomas ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]