By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,970 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

Cast result set of select into an array for a sub select...

P: n/a
CROSSPOSTED.. I know.... No-one seems to have an answer...

I have this SQL Statement which selects tablename.columname from a view...
thats not the point... I got the data I want but not the format I want...

SELECT (relname ||'.'|| attname) AS selection FROM v_product_imported_map;

which results in:
row selection
1 p_product_imported.custom_meta_tag
2 p_product_imported.price
3 p_product_imported.gift
4 p_product_imported.product_name
....
....

I'd like to retrieve this result as an array like this:

p_product_imported.custom_meta_tag, p_product_imported.price,
p_product_imported.gift, p_product_imported.product_name, ...

So that I can do a subselect like:

SELECT p_product_imported.custom_meta_tag, p_product_imported.price,
p_product_imported.gift, p_product_imported.product_name, ...
Any one with an idea on how to cast a result set of tablename.columnnames
into an array of tablename.columnnames ???

--
Greg Patnude / The Digital Demention
2916 East Upper Hayden Lake Road
Hayden Lake, ID 83835
(208) 762-0762

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.