Re: Feature request - Add microsecond as a time unit for interval

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