Re: Performance inside and outside view ( WAS Re: Select the

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: Gaetano Mendola <mendola(at)bigfoot(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Performance inside and outside view ( WAS Re: Select the
Date: 2002-09-12 18:57:07
Message-ID: 8920.1031857027@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> On Thu, 12 Sep 2002, Tom Lane wrote:
>> What's the datatype of id_user, and why are you quoting the compared
>> constant in some cases but not others? I don't think the difference
>> has anything to do with the view here ...

> At least in current sources it would, since it can't push down the clause
> (unless I'm misreading subquery_is_pushdown_safe and the comment) through
> the distinct on.

Oh, duh, you're right; I'd missed the DISTINCT ON ...

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Perrin 2002-09-12 19:11:45 LIMIT within UNION?
Previous Message david williams 2002-09-12 18:12:37 Returning a reference to a cursor from a function