Hello there,

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);
  (2 rows)

instead of:

  select * from foo where id in (?,?);
  select * from foo where id in (?,?,?);
  select * from foo where id in (?);
  select * from foo where id in (select id from foo);
  (4 rows)

?


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to