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