Why does the planner reduce the planned rows when filtering single values in an array

2023-04-21 Thread Isaiah Langford
When I run the following, on PostgreSQL 13.5: SELECT single_value INTO pg_temp.single_value_table FROM generate_series(1, 1) AS single_value; SELECT series_value, ARRAY[1] AS single_value_array INTO pg_temp.series_with_arrays FROM generate_series(1, 10) AS series_value; ANALYZE pg_temp.singl

Re: Why does the planner reduce the planned rows when filtering single values in an array

2023-04-22 Thread Isaiah Langford
Thank you Tom, Every tool is a work in progress. Knowing it's just a fact of life for now is really helpful, I appreciate the response. From: Tom Lane Sent: Saturday, April 22, 2023 12:43 AM To: Isaiah Langford Cc: pgsql-general@lists.postgresql.org Su