David Tulloh <david.tulloh@anu.edu.au> writes:
> To insert microseconds I have to use the following line, ($1*0.000001 ||
> ' seconds')::interval
Actually, the preferred way to do that is to use the numeric-times-interval
operator, eg
regression=# select 7 * '0.000001 second'::interval; ?column?
-----------------00:00:00.000007
(1 row)
This generalizes to any scale factor you care to use, eg fortnights...
so I don't see a pressing need to add microseconds.
regards, tom lane
