David Tulloh <david(dot)tulloh(at)anu(dot)edu(dot)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