I've worked with arrays of UDTs a bit in the past, and have encoded
them to text and cast on the query side. This isn't exactly pretty,
but it works fine. Arrays have one set of syntax rules, UDTs a
slightly different set, and then you need to take into account
standard_conforming_strings (or at least work with the setting of
standard_conforming_strings that you expect, if you know it will be
consistent). Don't think about standard_conforming_strings until the
very last step--this keeps things simpler and should let you nest UDTs
and arrays arbitrarily deep. I can't find the relevant documentation
with a quick search, but if you point out what you think is
inconsistent maybe I can help explain.
---
Maciek Sakrejda | System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com
