Feature request - Add microsecond as a time unit for interval
David Tulloh <david.tulloh@anu.edu.au>
From: David Tulloh <david.tulloh@anu.edu.au>
To: pgsql-hackers@postgresql.org
Date: 2006-02-09T04:16:22Z
Lists: pgsql-hackers
The interval datatype can go to microsecond precision though currently the smallest unit is seconds. Microseconds are represented as decimal places, eg 5 microseconds is 0.000005 seconds. To insert microseconds I have to use the following line, ($1*0.000001 || ' seconds')::interval Being able to specify microseconds as a unit would avoid hacks like this and improve support for sub-second intervals. David