Re: INTERVAL data type and libpq - what format? - Mailing list pgsql-general

From Ron Mayer
Subject Re: INTERVAL data type and libpq - what format?
Date
Msg-id 4A13D036.9070406@cheapcomplexdevices.com
Whole thread Raw
In response to Re: INTERVAL data type and libpq - what format?  (Sam Mason <sam@samason.me.uk>)
Responses Re: INTERVAL data type and libpq - what format?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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...



pgsql-general by date:

Previous
From: "Chen, Dongdong (GE Healthcare)"
Date:
Subject: Can I pause the pg_dump or pg_restore
Next
From: Raymond O'Donnell
Date:
Subject: Re: Can I pause the pg_dump or pg_restore