From: | Ian Barwick <barwick(at)gmx(dot)net> |
---|---|
To: | Alexander Blüm <mailinglists1(at)gmx(dot)de>, Postgresql General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: IIRC + intervals + and other things |
Date: | 2003-07-09 23:03:45 |
Message-ID: | 200307100103.45781.barwick@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thursday 10 July 2003 00:45, Alexander Blüm wrote:
> 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 time accuracy, but abstime
> > takes less storage space IIRC.
>
> where do I find information on different "intervals" and things like that?
These link mights help:
http://techdocs.postgresql.org/techdocs/faqdatesintervals.php
http://www.postgresql.org/docs/7.3/static/datatype-datetime.html
> and what is IIRC ? Intelligent Inter Relay Chat ? no, probably not.
;-) "If I recall correctly"
HTH
Ian Barwick
barwick(at)gmx(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Tkach | 2003-07-09 23:22:50 | Re: Rules and actions involving multiple rows |
Previous Message | Alexander Blüm | 2003-07-09 22:45:23 | IIRC + intervals + and other things |