From: | "Patrick Hatcher" <PHatcher(at)macys(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | varchar return data split into int4? |
Date: | 2002-07-19 04:42:56 |
Message-ID: | OF129B1594.FDD0DFBB-ON88256BFB.0018DA50-88256BFB.0019EBDE@fds.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Pierre-Yves Landuré | 2002-07-19 07:05:29 | problem using ?# operator on polygon |
Previous Message | April L | 2002-07-19 03:32:35 | Re: mirroring databases |