Re: distinct on extract returns composite type

In my query I wrapped the columns with distinct : distinct (extract year... , extract quarter..). In your query you didnt wrap the columns with distinct but you just mentioned it. I guess this is the difference, thanks ! >

Re: distinct on extract returns composite type

Mariel Cherkassky writes: > In my query I wrapped the columns with distinct : distinct (extract year... > , extract quarter..). > In your query you didnt wrap the columns with distinct but you just > mentioned it. I guess this is the difference, thanks ! Yeah. DISTINCT does not have an argument,

Re: distinct on extract returns composite type

Understood, thanks for explanation Tom!