Hi,
I am using Postgres 8.3. I have a table defined like this:
===
-- Table: timeson
-- DROP TABLE timeson;
CREATE TABLE timeson
(
id bigint NOT NULL,
enddatetime timestamp without time zone NOT NULL,
startdatetime timestamp without time zone NOT NULL,
times_id bigin
Thanks Gerhard, interesting but I wonder if it is a maintained project, the
files date from May 2008 and there is not much forum activity. I'll out it
on my list of "To be investigated".
Fred
On Wed, Aug 26, 2009 at 22:26, Gerhard Heift <
ml-postgresql-20081012-3...@gheift.de> wrote:
> But curre
, Sam Mason wrote:
> On Mon, Aug 24, 2009 at 05:24:59PM +0800, Fred Janon wrote:
> > I am using 8.3 and pgAdmin III. I have a couple of tables using 2 DATE
> > columns like 'startdate' and 'enddate' (just date, not interested in time
> in
> > these c
Hi,
I am using 8.3 and pgAdmin III. I have a couple of tables using 2 DATE
columns like 'startdate' and 'enddate' (just date, not interested in time in
these columns). I have some queries (some using OVERLAPS) involving both
'startdate' and 'enddate' columns. I tried to create a multi column index
