I originally sent this question to the Novice group, but realized I should
have asked it here:
I have a table that contains a VARCHAR field with data formatted as such:
12,44,13,225
what I would like to do is use this field in a query to another table such
as:
CREATE TABLE category_tree (
tree varchar(200)
) WITH OIDS;
Select * from mdc_products
where keyf_category_home IN (select tree from category_tree)
However, my keyf_category_home field is an INT4. Is there a way to parse
out the tree field so that I can define it as INT4?
TIA
Patrick Hatcher