Peter Mogensen wrote: > I have an application where I would really like to be able to look at en > SQL query and answer the question: > > "Is this query capable of returning more than 1 row?" > Can I conclude that when plan_rows is 1 then there will never be more > than 1 row returned by the query? I would say no. If the planner estimates one row, that means that it guesses that it will be one or less. And a query that can potentially return many rows can certainly also return only one row or none at all. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
