Help on constructing a query that matches array - Mailing list pgsql-general

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            |  Dog
2            |  Cat
3            |  Fish
4            |  Bird

Basically I am trying to create a SELECT query that returns the type of pets
an owner has by matching the pet_ids up. Can anyone help me with this?
--
View this message in context:
http://old.nabble.com/Help-on-constructing-a-query-that-matches-array-tp27234475p27234475.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.