Interval of 0s is invalid

[obs-gh-patrickscott]

Describe the bug
An interval of 0s is serialized to a blank string due to 01d649b

It used to serialize to 00:00:00.000000. Now postgres will error if a 0s interval is serialized. This is because Value() uses the TextFormatCode which uses this new format.

Expected behavior
Inserting a 0s interval should be fine.

Actual behavior
[Postgres](pq: invalid input syntax for type interval: "")

Version

• Go: 1.21.7
• PostgreSQL: PostgreSQL 13.6 (Debian 13.6-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
• pgx: 5.6.0

Additional context
Add any other context about the problem here.

[obs-gh-patrickscott]

In addition to the above issue, an interval of something simple like 6 minutes will serialize to ' 00:06:00' (note the leading space).

[jackc]

@exekias ⬆️

[exekias]

Most likely I introduced this issue 🙏, let me check, happy to open a PR to fix it!

[exekias]

#2035