Home > mailing lists

Index on date_trunc - Mailing list pgsql-sql

From	Christophe Labouisse
Subject	Index on date_trunc
Date	April 22, 1999 19:27:12
Msg-id	m3r9pcbe3m.fsf@gabuzo.meunet Whole thread Raw
List	pgsql-sql

Tree view

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/

pgsql-sql by date:

From: "Justin Long"
Date: 22 April 1999, 17:53:35
Subject: SELECT TOP X -- part 2 -- parse error?

From: JT Kirkpatrick
Date: 22 April 1999, 19:30:09
Subject: backend closing channel unexpectedly

Index on date_trunc - Mailing list pgsql-sql

Previous

Next