Postgres Pro
Downloads
Home   >   mailing lists

Re: Function returns error (view) - Mailing list pgsql-sql

From Markus Bertheau
Subject Re: Function returns error (view)
Date
Msg-id 684362e10802270109y7d63d656jbdff332274a31456@mail.gmail.com
Whole thread Raw
In response to Re: Function returns error (view)  ("Bart Degryse" <Bart.Degryse@indicator.be>)
Responses Re: Function returns error (view)
List pgsql-sql
Tree view 
2008/2/27, Bart Degryse <Bart.Degryse@indicator.be>:
>
> I would also suggest you replace the
> ...t.cod_user IN (subselect)
> by a join construction. I think it's more performant.

In recent versions PostgreSQL is quite smart when planning IN, so that
shouldn't be a concern.

Markus

-- 
Markus Bertheau
Blog: http://www.bluetwanger.de/blog/

pgsql-sql by date:

Previous
From: "Bart Degryse"
Date:
Subject: Re: Function returns error (view)
Next
From: "Bart Degryse"
Date:
Subject: Re: Function returns error (view)