Обсуждение: IIRC + intervals + and other things
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
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@gmx.net
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@gmx.net > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend >
ok, thank you people very much, this did indeed help! one more question though: is there a list for this kind of possibilities? time::TEXT::INTERVAL I mean, I now know about INTERVALS, but someone actually showed me this solution to one problem I once had. the question is, what other combinations are possible. If I knew all combinations or could simply look them up, that'd very helpful. HAND + TIA ;-) alex Csaba Nagy wrote: > 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@gmx.net