Re: interval( 'seconds 27960' ) is broken

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: elein@nextbus.com, pgsql-bugs@postgresql.org
Date: 2001-05-08T01:46:10Z
Lists: pgsql-bugs
pgsql-bugs@postgresql.org writes:
> In 7.0.3, I'm converting seconds from midnight to a time of
> day using interval ( 'seconds <val>').  This worked fine in 
> 7.0.3 and gives a Bad interval external representation message
> in 7.1.

This has never been the intended or documented format; it should
be '<val> seconds'.  Allowing both is ambiguous, so I'd say that
the behavior change is a correct one.

			regards, tom lane