At Postgres documentation page Date/Time Types, it says:
For the time types, the allowed range of p is from 0 to 6 when eight-byte integer storage is used, or from 0 to 10 when floating-point storage is used.
I tried to produce SQL statement with
p=10? I always get
WARNING: TIME(10) precision reduced to maximum allowed, 6
No matter if I put seconds in float or not. I realize I'm missing something very obvious. Please give an example when p=10.