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
, 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
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
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
