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

Port Bug Report: date<'abstimevalue+TIMEZONE' fails

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: date<'abstimevalue+TIMEZONE' fails
Date: 1999-03-17 17:32:49
Message-ID: 199903171732.MAA95294@hub.org (view raw or flat)
Thread:
Lists: pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		: Nir Oren
Your email address	: nir(at)global(dot)co(dot)za

Category		: unknown
Severity		: non-critical

Summary: date<'abstimevalue+TIMEZONE' fails

System Configuration
--------------------
  Operating System   : Linux 2.0.34 ELF (Redhat 5.1)

  PostgreSQL version : 6.4.2

  Compiler used      : egcs???

Hardware:
---------
P200 64Mb, uname:Linux hecate.neuralware.co.za 2.0.34 #1 Fri May 8 16:05:57 EDT 1998 i586 unknown

Versions of other tools:
------------------------
not sure, std redhat stuff

--------------------------------------------------------------------------

Problem Description:
--------------------
let abstime be a abstime type together with a timezone (SAST)
The following works: select * from mytable where datetime<abstime
however select * from mytable where datetime>abstime
fails if the timezone is included, without the timezone, it works

--------------------------------------------------------------------------

Test Case:
----------
As described above, 
SELECT * from mytable WHERE time<'Wed Mar 17 18:55:19 1999 SAST'
works
SELECT * from mytable WHERE time>'Wed Mar 17 18:55:19 1999 SAST'
returns no results, but
SELECT * from mytable WHERE time>'Wed Mar 17 18:55:19 1999'
does work

--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------


pgsql-ports by date

Next:From: Quoc LeDate: 1999-03-18 20:01:43
Subject: unixware 7 port
Previous:From: TorrezDate: 1999-03-17 10:41:36
Subject: test

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