Date Index
| От | Ryan Hansen |
|---|---|
| Тема | Date Index |
| Дата | |
| Msg-id | 001e01c93ad0$ffcbe190$ff63a4b0$@hansen@brightbuilders.com обсуждение исходный текст |
| Ответы |
Re: Date Index
|
| Список | pgsql-sql |
<div class="Section1"><p class="MsoNormal">Hey all,<p class="MsoNormal"> <p class="MsoNormal">I’m apparently too lazy tofigure this out on my own so maybe one of you can just make it easy on me. <span style="font-family:Wingdings">J</span> <p class="MsoNormal"> <p class="MsoNormal">I want to index a timestamp field but Ionly 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 forthis.<p class="MsoNormal"> <p class="MsoNormal">Any suggestions?<p class="MsoNormal"> <p class="MsoNormal">Thanks!</div>
В списке pgsql-sql по дате отправления: