From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
---|---|
To: | Ian Barwick <barwick(at)gmx(dot)net> |
Cc: | Alexander Blüm <mailinglists1(at)gmx(dot)de>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: IIRC + intervals + and other things |
Date: | 2003-07-10 08:23:54 |
Message-ID: | 1057825434.1103.57.camel@coppola.ecircle.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
For the IIRC, HTH and other similar stuff you will find this a good
help:
http://www.acronymfinder.com/
Cheers,
Csaba.
On Thu, 2003-07-10 at 01:03, Ian Barwick wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-07-10 08:33:47 | Re: Dynamic plpgsql code |
Previous Message | Csaba Nagy | 2003-07-10 08:19:21 | Re: Dynamic plpgsql code |