Patryk Kordylewski wrote:
I made a test-case which is not working for me. Perhaps something wrong
with the SELECT DISTINCT ON () syntax when i specify more then 1 column?
At first this was working when i specified only one column in the SELECT
DISTINCT ON-clause, then i inserted a dummy column "second_distinct" and
put it into the clause and it's not working anymore.
PG Version: 8.2.4
http://fooby.imosnet.de/not_working.txt
Thanks for help,
Patryk
I think i found the problem and made 2 sql files to reproduce it. The
only difference between this 2 files is the order by-clause of the view...
http://fooby.imosnet.de/order_by_working.txt
http://fooby.imosnet.de/order_by_not_working.txt
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
