This...on 9.3

SELECT array_agg(
distinct case when v % 2 = 0 then 'odd' else 'even' end
order by case when v % 2 = 0 then 1 else 2 end
)
FROM (VALUES (1), (2), (3)) val (v)

I'm not particularly irked at this though I was hoping to fix a somewhat
complex query of mine by simply adding a "DISTINCT" to the array_agg that I
am building from derived (using CASE) data.

I am curious to the reason for the limitation, particularly as it would
relate to this specific instance.

Any givers?

Thank!

David J.

Reply via email to