Skip site navigation (1) Skip section navigation (2)

Re: BUG #1993: Adding/subtracting negative time intervals

From: Russell Smith <mr-russ(at)pws(dot)com(dot)au>
To: Nicholas <hb(at)x256(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1993: Adding/subtracting negative time intervals
Date: 2005-10-24 22:51:59
Message-ID: 435D658F.7040505@pws.com.au (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
Nicholas wrote:
> The following bug has been logged online:
> 
> Bug reference:      1993
> Logged by:          Nicholas
> Email address:      hb(at)pg(dot)x256(dot)org
> PostgreSQL version: 8.0.3,8.0.4,8.1
> Operating system:   Gentoo Linux
> Description:        Adding/subtracting negative time intervals changes time
> zone of result
> Details: 
> 
> spatula ~ # psql -U postgres
> Welcome to psql 8.1beta1, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> postgres=# SELECT VERSION();
>                                                                version
> ----------------------------------------------------------------------------
> ----------------------------------------------------------
>  PostgreSQL 8.1beta1 on i686-pc-linux-gnu, compiled by GCC
> i686-pc-linux-gnu-gcc (GCC) 3.3.6 (Gentoo 3.3.6, ssp-3.3.6-1.0, pie-8.7.8)
> (1 row)
> 
> postgres=# SELECT NOW()-interval '1 week';
>            ?column?
> -------------------------------
>  2005-10-17 08:52:37.355219+10
> (1 row)
> 
> postgres=# SELECT NOW()-interval '-1 week';
>            ?column?
> -------------------------------
>  2005-10-31 08:52:39.021583+11

Looks to mee like Daylight Savings has conveniently started.

> (1 row)
> 
> postgres=#
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
> 
> 


In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2005-10-24 23:02:07
Subject: Re: New timezone data
Previous:From: Simon RiggsDate: 2005-10-24 22:46:34
Subject: Re: Seeing context switch storm with 10/13 snapshot of

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2005-10-24 23:12:11
Subject: Re: BUG #1985: cannot insert Chinese character into a table encoded
Previous:From: Ludmil TinkovDate: 2005-10-24 21:22:13
Subject: BUG #1996: DISTINCT fails with national character varying

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group