Re: distinct on extract returns composite type

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: Félix GERZAGUET <felix(dot)gerzaguet(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: distinct on extract returns composite type
Date: 2019-09-30 13:42:02
Message-ID: CA+t6e1=yZEKMGT_qmJHB7E6Rj2S+G06mr4DL=ZDNo9Ru4DGr=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 !

>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2019-09-30 13:48:16 Re: distinct on extract returns composite type
Previous Message Tom Lane 2019-09-29 15:32:23 Re: sequence depends on many tables