IIRC + intervals + and other things - Mailing list pgsql-general

From Alexander Blüm
Subject IIRC + intervals + and other things
Date
Msg-id 3F0C9B03.5000204@gmx.de
Whole thread Raw
Responses Re: IIRC + intervals + and other things  (Ian Barwick <barwick@gmx.net>)
List pgsql-general
hello,

I am getting more and more confused with statements like these

> update foo set  timestamp_field  = timestamp_field + '365
> days'::interval;

or

> I normaly use 'abstime' and 'reltime' for dates and intervals, the major difference is 'timestamp' has microsecond
timeaccuracy, but abstime takes less storage space IIRC.  

where do I find information on different "intervals" and things like that?

or even this:

   time::TEXT::INTERVAL

and what is IIRC ? Intelligent Inter Relay Chat ? no, probably not.

well, please answer gently, since I just showed my non-knowledge.

TIA



pgsql-general by date:

Previous
From: Guy Fraser
Date:
Subject: Re: Date Math
Next
From: Ian Barwick
Date:
Subject: Re: IIRC + intervals + and other things