I picked up a function from the Pg Cookbook that pulls back data in a tree
fashion
(http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=15).
The end result of the data is returned as a VARCHAR in this fashion:
0,122,144,1,229.......
I would like to use the result of the function in a query that requires the
result to be an INT4. Is it possible to split the result into individual
numbers?
Here's how I would like to use the query:
Select * from mdc_products
where keyf_category_home IN (select category_code(160))
When I run this, I get 0 results. If I manually run the select
category_code(160) and paste the results within the IN statement, I get
data. This leads me to believe that because the return data from the
function is VARCHAR, it won't work.
TIA
Patrick Hatcher