> than part number order, put the whole thing in a sub-select and re-sort
> outside it.
>
> regards, tom lane
>
> "Clark Slater" writes:
>> I am trying to use DISTINCT ON to filter out *potential* duplicate
>> values
>> from a set of
Hello-
I am trying to use DISTINCT ON to filter out *potential* duplicate values
from a set of sub queries. There are certain cases where there can be
repetitive part numbers that are priced differently. I'm trying to start
with the full list, ordered by priority, and then remove any repeats tha
Hello-
I am working on an e-commerce system that has different lists of products
which contain many of the same products, at different prices. When a user
searches for a certain set of part numbers, I would like the resulting
products (and prices) to come from one of the lists, according to the
l
