Re: distinct on extract returns composite type
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: distinct on extract returns composite type
From
: Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx>
Date
: Mon, 30 Sep 2019 16:42:02 +0300
Cc
: pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to
: <CANVwZtuzT1w0aVQMyBi+U=d7e_HQmB70THnqZoxu=xooVRvhbA@mail.gmail.com>
References
: <CA+t6e1=FjpvAOwGXveustdC11VbSBrZ2_pVKGKaVFqAvVJh+QQ@mail.gmail.com> <CANVwZtuzT1w0aVQMyBi+U=d7e_HQmB70THnqZoxu=xooVRvhbA@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 !
Follow-Ups
:
Re: distinct on extract returns composite type
From:
Tom Lane
References
:
distinct on extract returns composite type
From:
Mariel Cherkassky
Re: distinct on extract returns composite type
From:
Félix GERZAGUET
Prev by Date:
Re: sequence depends on many tables
Next by Date:
Re: distinct on extract returns composite type
Previous by thread:
Re: distinct on extract returns composite type
Next by thread:
Re: distinct on extract returns composite type
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
