| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Dave Smith <dave(dot)smith(at)candata(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Using IN with subselect |
| Date: | 2004-11-25 17:25:46 |
| Message-ID: | 20041125172542.GC28393@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Nov 25, 2004 at 12:19:23PM -0500, Dave Smith wrote:
> Well here is explain. I would guess that it is executed each time ..
> function any different?
Hmm, if it's only executed once I would expect it to be an InitPlan.
Are you sure it's not correlated?
If you want to make sure, put the subquery in the FROM clause, that it
definitly will only be run once.
<snip>
Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-11-25 17:57:01 | Re: Using IN with subselect |
| Previous Message | Julian Scarfe | 2004-11-25 17:23:35 | How can I change a cast from explicit only to implicit? |