Re: distinct on extract returns composite type
Mariel Cherkassky <[email protected]> Mon, 30 Sep 2019 16:42:02 +0300
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <CA+t6e1=yZEKMGT_qmJHB7E6Rj2S+G06mr4DL=ZDNo9Ru4DGr=w@mail.gmail.com> |
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 ! >