On Mon, Dec 27, 2004 at 12:18:53 -0500,
Keith Worthington <keithw@narrowpathinc.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.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match