Thomas Beutin <tyrone@laokoon.IN-Berlin.DE> writes:
> i cannot create an index like this:
> CREATE INDEX "stat_pages_datum_idx" on "stat_pages" ( date ("visit") );
You are overthinking the problem. A plain index on "visit" would work
fine for the example query you gave.
regards, tom lane