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

Reply via email to