Skip site navigation (1) Skip section navigation (2)

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: 2008-02-27 09:09:54
Message-ID: 684362e10802270109y7d63d656jbdff332274a31456@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
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/

In response to

Responses

pgsql-sql by date

Next:From: Bart DegryseDate: 2008-02-27 09:16:51
Subject: Re: Function returns error (view)
Previous:From: Bart DegryseDate: 2008-02-27 07:52:58
Subject: Re: Function returns error (view)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group