Postgres Pro
Downloads
Home   >   mailing lists

Re: distinct on extract returns composite type - Mailing list pgsql-performance

From Mariel Cherkassky
Subject Re: distinct on extract returns composite type
Date
Msg-id CA+t6e1=yZEKMGT_qmJHB7E6Rj2S+G06mr4DL=ZDNo9Ru4DGr=w@mail.gmail.com
Whole thread Raw
In response to Re: distinct on extract returns composite type  (Félix GERZAGUET <felix.gerzaguet@gmail.com>)
Responses Re: distinct on extract returns composite type
List pgsql-performance
Tree view
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 !

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: sequence depends on many tables
Next
From: Tom Lane
Date:
Subject: Re: distinct on extract returns composite type