David Tulloh <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
