functional indexes
От | Daniel Kalchev |
---|---|
Тема | functional indexes |
Дата | |
Msg-id | 199809260953.MAA06545@dcave.digsys.bg обсуждение исходный текст |
Ответы |
Re: [HACKERS] functional indexes
|
Список | pgsql-hackers |
With the current snapshot, there seems to be problem with functional indexes. Example: CREATE TABLE timelog (loginname text, site varchar(16), start_time datetime, elapsed timespan); CREATE FUNCTION datetime_day (datetime ) RETURNS float8 AS 'select date_part(''day'', $1)' LANGUAGE 'SQL'; INSERT INTO timelog values ('abc','varna','Thu 01 Jan 23:23:34 1998 EET','@ 10 mins'); INSERT INTO timelog values ('abc','sofia','Thu 01 Jan 23:23:34 1998 EET','@ 2 hours 10 mins'); $ psql test Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL type \? for help on slash commands type \q to quit type \g or terminate with semicolon to execute query You are currently connected to the database: test test=> create index timelog_date_idx on timelog (datetime_day(start_time)); ERROR: DefineIndex: (null) class not found test=> Also, using date_part() directly in the index definition: test=> create index timelog_date_idx on timelog (datetime_part('day', start_time)); ERROR: parser: parse error at or near "'" Can something be done about this before 6.4 is released? Daniel
В списке pgsql-hackers по дате отправления: