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 has

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 > TO_TIMESTAMP(15391009