Re: [PERFORM] Index on a function and SELECT DISTINCT

Frank Wiles wrote: > Adrian Holovaty <[EMAIL PROTECTED]> wrote: > > If I have this table, function and index in Postgres 7.3.6 ... > > > > """ > > CREATE TABLE news_stories ( > > id serial primary key NOT NULL, > > pub_date timest

[PERFORM] Index on a function and SELECT DISTINCT

If I have this table, function and index in Postgres 7.3.6 ... """ CREATE TABLE news_stories ( id serial primary key NOT NULL, pub_date timestamp with time zone NOT NULL, ... ) CREATE OR REPLACE FUNCTION get_year_trunc(timestamp with time zone) returns timestamp with time zone AS 'SEL