DBA requires basic SQL assistance please (LONG POST)

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 11 Mar 2003 09:54:39 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7036895A4@lnewton.leeds.lfs.co.uk>

Martin,

Thanks for that - I never used that sort of object casting before when I got it to work. However, I'll give it a try.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Martin Burbridge [mailto:pobox002_at_bebub.com] Posted At: Tuesday, March 11, 2003 1:36 AM Posted To: server
Conversation: DBA requires basic SQL assistance please (LONG POST) Subject: Re: DBA requires basic SQL assistance please (LONG POST)

Hello Norman,

I think you can do what you are trying if your function returns an object type, and you use the table cast syntax in the select in the subquery. There may be other ways to do this but this is what I normally use.

Here's an example the function get_list just takes a comma delimited string and returns an array of type str_list.

Hopefully you can make sense of it.

<SNIP EXAMPLE> Received on Tue Mar 11 2003 - 03:54:39 CST