Re: [HACKERS] time interval behaviour seems odd

2003-12-17 Thread Tom Lane
Tom Lane <[EMAIL PROTECTED]> writes: > Tilo Schwarz <[EMAIL PROTECTED]> writes: >> tschwarz=> select '-0.1'::interval; >> interval >> - >> 00:00:00.10 <--- >> (1 row) > This is incontestably a bug. Will fix for 7.4.1. I've applied the attached patch to 7.4 and HEAD. It'd probably

Re: [HACKERS] time interval behaviour seems odd

2003-12-17 Thread Tom Lane
Tilo Schwarz <[EMAIL PROTECTED]> writes: > while trying to create a query this afternoon dealing with intervals, I > noticed the following behaviour and I wondered, if it is intended. > tschwarz=> select '-1'::interval; > interval > -- > -01:00<--- > (1 row) This appears to be

[HACKERS] time interval behaviour seems odd

2003-12-17 Thread Tilo Schwarz
Hi, while trying to create a query this afternoon dealing with intervals, I noticed the following behaviour and I wondered, if it is intended. (It was non-intuitive to me and if there was a warning in the docs i missed it.) The lines marked <--- make me wonder ... tschwarz=> select version(