It might be useful to look at the capabilities of the Informix Timeseries
Datablade
(http://www-01.ibm.com/software/data/informix/blades/)
if you want to look at ways of enhancing the temporal data capabilities of
Postgres.
Cheers,
Brent
Brent Wood
DBA/GIS consultant
NIWA, Wellington
Ne
On 15/12/2008 15:09, Chris Browne wrote:
> PostgreSQL has pretty nice time types between the timestamptz type and
> interval.
Yeah... I've often gotten really frustrated trying to do date- and
time-related stuff in PHP - it's much easier to get PG to do it instead. :-)
Ray.
rshep...@appl-ecosys.com (Rich Shepard) writes:
>
> [2] Strangely enough -- to me, at least -- the lack of full support for
> date- and time-based SQL in database tools such as PostgreSQL is puzzling.
> Virtually all business-related databases (think accounting systems as a
> prime example) depend
On Sun, 14 Dec 2008, Michael Hall wrote:
I'm wondering if anyone can recommend a good general book on relational
database design.
...
Mick,
I highly recommend all the books by Joe Celko. He's been writing on
database issues for at least 20 years and communicates very well. I know
that he h
This is slightly off topic perhaps, but maybe not too much ...
I'm wondering if anyone can recommend a good general book on relational
database design. I am using PostgreSQL, so a PG-centric book would be best, but
I'm mainly interested in the art/science of good SQL database design regardless
