Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Function returns error (view)
- From: "Markus Bertheau" <mbertheau(dot)pg(at)googlemail(dot)com>
- To: "Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be>
- Cc: "Professor Flávio Brito" <prof(dot)flaviobrito(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
- Subject: Re: Function returns error (view)
- Date: Wed, 27 Feb 2008 15:09:54 +0600
2008/2/27, Bart Degryse <Bart(dot)Degryse(at)indicator(dot)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/
- Follow-Ups:
- Re: Function returns error (view)
- From: Bart Degryse
- Re: Function returns error (view)
- References:
- Function returns error (view)
- From: Professor Flávio Brito
- Re: Function returns error (view)
- From: Professor Flávio Brito
- Re: Function returns error (view)
- From: Bart Degryse
- Function returns error (view)
- Prev by Date: Re: Function returns error (view)
- Next by Date: Re: Function returns error (view)
- Previous by thread: Re: Function returns error (view)
- Next by thread: Re: Function returns error (view)
- Indexes: