Re: [GENERAL] Help on constructing a query that matches array

2010-01-20 Thread Dean Rasheed
2010/1/19 BlackMage : > > Hey all, > > I need help on constructing a query with arrays that matches the arrays up > as foriegn keys to another table. For example, say that I have two tables, > owners and pets. > > Owner Table > owner_id | pet_ids > 1             |    {1,2,3} > 2             |    {2

[GENERAL] Help on constructing a query that matches array

2010-01-19 Thread BlackMage
Hey all, I need help on constructing a query with arrays that matches the arrays up as foriegn keys to another table. For example, say that I have two tables, owners and pets. Owner Table owner_id | pet_ids 1 |{1,2,3} 2 |{2,3} Pet Table pet_ids | Pet Type 1