On Wednesday, 11 October 2023 at 08:58:32 UTC+2 Lukas Eder wrote: Hah, indeed, that doesn't work in PostgreSQL, neither does any other expression on a (in ORDER BY). So, I'd also like to conclude this, with my pinned tweet: https://twitter.com/lukaseder/status/1526262253284106253
(The following would work, but I forgot what the point of all this is): select a from ( select row (x, y) as a from (values (1, 2)) t (x, y) ) as t order by (a).f1; Well ok, that does work, though it's a bit annoying that I cannot reference "x" or "y" in the ORDER BY clause, but have to use "f1". Anyway, I think there's no real point to this anymore, because I'm not gonna use this specific SQL. We ended up here, because I wanted to understand which kind of references to selected rows work (or don't) in an ORDER BY clause. That's settled for me now. :) Thanks for your help, again! -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/c90e89ef-5a61-4c60-b677-79c0a5486ad1n%40googlegroups.com.
