Robert Haas <robertmhaas@gmail.com> writes:
> Ooh, I like it. A related personal pet peeve of mine: AFAIK the
> easiest way to convert from an integer number of seconds to an
> interval representing that many seconds is:
> (the_int || ' s')::interval
No, the standard solution is
the_int * '1 second'::interval
which is fast and adapts readily to different units for the interval
number.
regards, tom lane