Can you select from inside postgres arrays?
Eg.
select name from games where categories[] = "Action";
or
select name from games where "Action" in categories[];
I didn't see anything like this in the Postgresql manual and am curious before I install Postgres. I could use another table for a link of categories and games but I run into other problems there. This simplifies everything, I am just wondering if this is feasible.
`Kevin
Eg.
select name from games where categories[] = "Action";
or
select name from games where "Action" in categories[];
I didn't see anything like this in the Postgresql manual and am curious before I install Postgres. I could use another table for a link of categories and games but I run into other problems there. This simplifies everything, I am just wondering if this is feasible.
`Kevin