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. -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
