Date Index

Поиск
Список
Период
Сортировка
От Ryan Hansen
Тема Date Index
Дата
Msg-id 001e01c93ad0$ffcbe190$ff63a4b0$@hansen@brightbuilders.com
обсуждение исходный текст
Ответы Re: Date Index
Список pgsql-sql

Hey all,

 

I’m apparently too lazy to figure this out on my own so maybe one of you can just make it easy on me. J 

 

I want to index a timestamp field but I only want the index to include the yyyy-mm-dd portion of the date, not the time.  I figure this would be where the “expression” portion of the CREATE INDEX syntax would come in, but I’m not sure I understand what the syntax would be for this.

 

Any suggestions?

 

Thanks!

В списке pgsql-sql по дате отправления: