Home > mailing lists

Re: INDEX suggestion needed - Mailing list pgsql-general

From	Magnus Naeslund(f)
Subject	Re: INDEX suggestion needed
Date	December 12, 2002 17:32:04
Msg-id	022301c2a215$242e9240$f80c0a0a@mnd Whole thread Raw
In response to	INDEX suggestion needed (Thomas Beutin <tyrone@laokoon.IN-Berlin.DE>)
List	pgsql-general

Tree view

Thomas Beutin <tyrone@laokoon.IN-Berlin.DE> wrote:
[snip all]

Does it help anything if you cast to the relevant type before executing,
i.e.:

( visit >= '2002-12-01'::timestamp AND visit <=
'2002-12-11'::timestamp )

Magnus

pgsql-general by date:

From: Mike Benoit
Date: 12 December 2002, 17:19:19
Subject: Re: Frustration with date/times/epoch in v7.3.

From: Bret Hughes
Date: 12 December 2002, 17:32:45
Subject: Re: PostgreSQL idocs

Re: INDEX suggestion needed - Mailing list pgsql-general

Previous

Next