On Fri, Oct 22, 2010 at 4:27 PM, Alvaro Herrera <alvhe...@commandprompt.com> wrote: > Excerpts from Alvaro Herrera's message of vie oct 22 17:13:31 -0300 2010: >> Excerpts from Robert Haas's message of vie oct 22 16:54:01 -0300 2010: >> >> > 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 >> >> Why do you go through text and concatenation? I advocate this approach: >> the_int * interval '1 second' > > A quick tests with pgbench custom scripts says that it's about 10% > faster.
Hmm, never thought of that approach. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
