Robert Haas <robertmh...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers