From: DHS Webmaster <webmaster@dhs-club.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: bizarre AGE behaviour
Date: Thu, 04 Mar 2004 13:40:06 -0500
Message-ID: <40477806.8B5F7E60@dhs-club.com> (raw)
References: <40461395.5324CFEE@dhs-club.com>
<200403031000.05524.scrawford@pinpointresearch.com>
<19029.1078355959@sss.pgh.pa.us>
<200403040857.39605.scrawford@pinpointresearch.com>
You are both right.
Your explanation, Steve, was the light that got me going on a simpler
solution along the lines of what Tom suggested. I didn't really need
AGE, and upon digging in, couldn't even remember why I had chosen that
in the first place.
Postgres is the bomb!
Thanks guys.
Steve Crawford wrote:
>
> On Wednesday 03 March 2004 3:19 pm, Tom Lane wrote:
> > Steve Crawford <scrawford@pinpointresearch.com> writes:
> > > US Daylight Saving Time starts this year on April 4 when 0200
> > > jumps to 0300. The answers PostgreSQL gave are correct.
> >
> > I suspect what the OP wants is non-timezone-aware behavior...
>
> You are probably right. In his original post he posited that the
> problem was due to some sort of leap-year bug in PostgreSQL. I was
> just pointing him to the real cause of his observations so he could
> tackle whatever problem he was having secure in the knowledge that PG
> was working correctly.
>
> Cheers,
> Steve
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
--
Bill MacArthur
Webmaster
The DHS Club, Inc.
The Best Is Yet To Come!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: webmaster@dhs-club.com
Subject: Re: bizarre AGE behaviour
In-Reply-To: <40477806.8B5F7E60@dhs-club.com>
References: <40461395.5324CFEE@dhs-club.com> <200403031000.05524.scrawford@pinpointresearch.com> <19029.1078355959@sss.pgh.pa.us> <200403040857.39605.scrawford@pinpointresearch.com> <40477806.8B5F7E60@dhs-club.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox