On Tue, Oct 9, 2018 at 9:32 AM Alexander Farber <alexander(dot)farber(at)gmail(dot)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.