> "David" == David G Johnston writes:
>> 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);
David> SELECT array_agg(words) FROM (
David> SELECT
On Tue, Oct 9, 2018 at 9:32 AM Alexander Farber
wrote:
>
> SELECT ARRAY_AGG(hashed)
>FROM words_nouns
>WHERE added > TO_TIMESTAMP(1539100913)
> UNION
> SELECT ARRAY_AGG(hashed)
> FROM words_verbs
> WHERE added >
Good evening,
I am trying to SELECT ARRAY_AGG into an array from 2 tables.
But unfortunately here is what I get in PostgreSQL 10.5:
SELECT ARRAY_AGG(hashed)
FROM words_nouns
WHERE added > TO_TIMESTAMP(1539100913)
UNION
SELECT ARRAY_AGG(hashed)
FROM