Postgres Pro
Downloads
Home   >   mailing lists

Re: is it helpful for the optimiser/planner to add LIMIT 1 - Mailing list pgsql-general

From Tom Lane
Subject Re: is it helpful for the optimiser/planner to add LIMIT 1
Date
Msg-id 29407.1207233236@sss.pgh.pa.us
Whole thread Raw
In response to Re: is it helpful for the optimiser/planner to add LIMIT 1  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: is it helpful for the optimiser/planner to add LIMIT 1  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Tree view 
Gregory Stark <stark@enterprisedb.com> writes:
> You could fix that more cleanly with "ALTER FUNCTION myfunction ROWS 1" but
> only if that's always true, not just for myfunction(3,5).

Perhaps the function shouldn't be declared SETOF in the first place?

            regards, tom lane

pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: is it helpful for the optimiser/planner to add LIMIT 1
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: is it helpful for the optimiser/planner to add LIMIT 1