Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT UNION into a text[] - Mailing list pgsql-general

From David G. Johnston
Subject Re: SELECT UNION into a text[]
Date
Msg-id CAKFQuwae8OoiPCC5+ryJ_k3R_-UrTOnWQS6O3JBQ6C3ieJpj5w@mail.gmail.com
Whole thread Raw
In response to SELECT UNION into a text[]  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: SELECT UNION into a text[]
List pgsql-general
Tree view
On Tue, Oct 9, 2018 at 9:32 AM Alexander Farber <alexander.farber@gmail.com> wrote:

SELECT ARRAY_AGG(hashed) 
               FROM words_nouns 
               WHERE added > TO_TIMESTAMP(1539100913)  
UNION
SELECT ARRAY_AGG(hashed) 
                FROM words_verbs 
                WHERE added > TO_TIMESTAMP(1539100913);                   


SELECT array_agg(words) FROM (
SELECT hashed FROM words_nouns
UNION ALL
SELECT hashed FROM words_verbs
) AS src

David J.

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: SELECT UNION into a text[]
Next
From: Bryce Pepper
Date:
Subject: RHEL 7 (systemd) reboot