Re: sequence depends on many tables

2019-09-29 Thread Tom Lane
Mariel Cherkassky writes: > seq_oid | classid | objid | objsubid | refclassid | refobjid | refobjsubid > | deptype > -+-+---+--++--+-+- >17188 |1259 | 17188 |0 | 1259 |17190 | 1 > | a >1656

Re: distinct on extract returns composite type

2019-09-29 Thread Félix GERZAGUET
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 col

distinct on extract returns composite type

2019-09-29 Thread Mariel Cherkassky
Hey, I'm working on PG12. I have the following table : \d dates_table Table "public. dates_table " Column | Type | Collation | Nullable |Default --+-+---+--+--- id