unixway.dr...@gmail.com writes:
> Given the following list of queries:
> create table foo (id serial, bar integer);
> select * from foo where id in (1);
> select * from foo where id in (2,3);
> select * from foo where id in (1,3,5);
> select * from foo where id in (select id from foo);
> would it be possible to have first three select queries to be normalized
> into a single one so that 'select query from pg_stat_statements' returns
> something like:
> select * from foo where id in (...);
> select * from foo where id in (select id from foo);
Wouldn't recommend holding your breath for that. But you could do the
same conversion on the client side that the parser would do anyway:
select * from foo where id = any ('{1,3,5}'::integer[]);
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
