I didn't specify the real problem as it's all wrapped up in layers and I
didn't want to post a "can someone write the query for me". The real
problem was I have a table with a string holding comma separated numbers,
and needed to go to a lookup table and replace each of those numbers with
it's cor
Thanks,
Unfortunately I believe I need to include a postgres module to get the "<@"
operator, which I have no power to do. This is what I get with that
operator..
select name from table_name_ds_tmp where categoryid <@ ANY ( ARRAY[ 200,
400]::BIGINT[] );
ERROR: operator does not exist: bigint
Perhaps someone can guide me here as I'm having a "moment". :)
Not sure why I am getting 0 rows returned here:
db=# \d table_name_ds_tmp
Column | Type| Modifiers
+---+---
categoryid | bigint|
name | character varying |
d
