Re: [BUGS] BUG #3431: age() gets the days wrong

2007-07-09 Thread Pelle Johansson
s 2 months and 29 days or 2 months and 30 days between 2006-11-02 and 2007-02-01... If one want mathematical correctness, it will have to be defined precisely. -- Pelle Johansson 8 jul 2007 kl. 22.07 skrev Tom Lane: "Pelle Johansson" <[EMAIL PROTECTED]> writes: The age(

[BUGS] BUG #3431: age() gets the days wrong

2007-07-06 Thread Pelle Johansson
The following bug has been logged online: Bug reference: 3431 Logged by: Pelle Johansson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Linux 2.6 Description:age() gets the days wrong Details: This might be a known issue but i couldn&#

Re: [BUGS] BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.

2007-02-22 Thread Pelle Johansson
16 feb 2007 kl. 22.00 skrev Tom Lane: "Pelle Johansson" <[EMAIL PROTECTED]> writes: We have a join where we select which row to join on a subquery with a coalesce on a column from a left join, which is not working as expected. The attached patch should fix this. Hi Tom,

[BUGS] BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.

2007-02-15 Thread Pelle Johansson
The following bug has been logged online: Bug reference: 3012 Logged by: Pelle Johansson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: RedHat CentOS 4.4 Description:Wrong JOIN order when a JOIN depends on result from a LEFT JOIN