On Mon, Dec 27, 2004 at 12:18:53 -0500,
Keith Worthington <keithw(at)narrowpathinc(dot)com> wrote:
> Hi Michael,
> I ended up with this query as I do not really care about the inventory_id in
> the end game. What about SELECT DISTINCT is non-standard? Are there any
> implications of using this other than portability?
It's the "ON" clause that is nonstandard. If you aren't worried about
portability than there isn't a problem with using that feature.
In response to
pgsql-novice by date
|Next:||From: Keith Worthington||Date: 2004-12-27 21:46:15|
|Subject: Calculating the difference between result columns|
|Previous:||From: Jaime Casanova||Date: 2004-12-27 19:48:45|
|Subject: Re: Rewritten queries |