> On 25 Sep 2019, at 22:50, Alban Hertroys <haram...@gmail.com> wrote: > > >> On 25 Sep 2019, at 22:25, David Salisbury <dsa...@ucar.edu> wrote: >> db=# select name from table_name_ds_tmp where ARRAY[categoryid] = ANY ( >> select string_to_array( '200,400', ',')::bigint[] ); >> name >> ------ >> (0 rows) > > You are comparing two arrays for equality. Since the left-hand array has only > 1 item and the right-hand one has two, there’s not much equality between them. > > You probably meant: > select name from table_name_ds_tmp where categoryid = ANY ( select > string_to_array( '200,400', ',')::bigint[] );
Or rather: select name from table_name_ds_tmp where categoryid = ANY ( string_to_array( '200,400', ',')::bigint[] ); Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest.
