Re: SELECT UNION into a text[]

2018-10-10 Thread Andrew Gierth
> "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

Re: SELECT UNION into a text[]

2018-10-09 Thread David G. Johnston
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 >

SELECT UNION into a text[]

2018-10-09 Thread Alexander Farber
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