Re: INTERVAL data type and libpq - what format?

Sam Mason wrote:
> You get an error because " 123 11" isn't a valid literal of an
> (undecorated) INTERVAL type.

Hmm..... should it be?
Skimming the spec makes me think it might be a valid day-time interval.

Quoting the spec:
<unquoted interval string> ::=
[ <sign> ] { <year-month literal> | <day-time literal> }
...
<day-time literal> ::=
<day-time interval>
| <time interval>
<day-time interval> ::=
<days value> [ <space> <hours value> [ <colon> <minutes value>
[ <colon> <seconds value> ] ] ]

I can send a patch if this interpretation is right...