Re: Creating Index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "CN" <cnliou9(at)fastmail(dot)fm>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Creating Index
Date: 2003-10-02 03:18:07
Message-ID: 11961.1065064687@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"CN" <cnliou9(at)fastmail(dot)fm> writes:
> Is creating a function that eats DATE as argument to build that index my
> only solution?

You haven't really explained what your problem is. In general I'd not
guess that "year >= X and month >= Y" is a useful operation if Y is
different from 1. You'd be selecting a very discontinuous set of
dates ...

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2003-10-02 05:37:10 Re: Creating Index
Previous Message Tom Lane 2003-10-02 03:10:59 Re: help with rule and notification