Hello,
On Sun, Sep 29, 2019 at 11:46 AM Mariel Cherkassky <
mariel.cherkas...@gmail.com> wrote:
> I'm keep getting composite type (row) instead of two columns. Is there any
> sql way to convert the row type into two columns ? I want to get the first
> and last dates of each quarter with those columns and with this composite
> type I failed doing it
>
This seems to work as you expect:
select distinct extract(year from end_time) as year, extract(quarter from
end_time) quarter from generate_series
( '2017-09-01'::timestamp
, '2019-04-01'::timestamp
, '3 month'::interval) end_time
;
https://www.postgresql.org/docs/current/sql-select.html#SQL-DISTINCT
--
Félix
