Re: SELECT UNION into a text[]

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Oct 9, 2018 at 9:32 AM Alexander Farber <alexander.farber@xxxxxxxxx> 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.