> "Stijn Vanroye" <[EMAIL PROTECTED]> writes:
> > I can't seem to find a way to substract two time values (or
> > timestamp values) and get a numeric/float value. I always get the
> > INTERVAL datatype.
>
> extract(epoch from interval) may help.
>
> regards, tom lane
Indeed. I think I should kick myself for missing that, I have read that section af the
manual four times or so, and missed it over and over again :)
Thanks for the help.
Regards,
Stijn Vanroye.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
