I'm trying to index on a part of a datetime field. I tried the
following statement :
create index ns_dt1_idx on netstats (date_trunc('day',NS_DATE) datetime_ops);
It doesn't work and I get :
ERROR: parser: parse error at or near "'"
Any idea ?
--
Christophe Labouisse : Cinéma, typographie, Unix
christophe.labouisse@dial.oleane.com http://www.multimania.com/gabuzo/
Le cinéma en Lumière : http://www.lumiere.org/
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.