Re: query question - Mailing list pgsql-novice

From Josh Berkus
Subject Re: query question
Date
Msg-id 200307030931.23692.josh@agliodbs.com
Whole thread Raw
In response to query question  (Michael Hanna <zen@hwcn.org>)
List pgsql-novice
Michael,

> Often there are multiple entries per day. I want to display the day
> once, with all the entries on that day.

Look in the docs under "Functions and Operators".  There is a function
specifically to truncate dates.   If you write a wrapper function around it,
you can even make it indexable ...

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-novice by date:

Previous
From: Manuel Sugawara
Date:
Subject: Re: query question
Next
From: Michael Hanna
Date:
Subject: query question