Nested tables and select statements

From: Sam Habbab <sam_at_hasc.com>
Date: 2000/07/10
Message-ID: <396A20EB.89D27122@hasc.com>#1/1

Hi,

I'm trying to create a table dynamically of two columns a and b, fill it then return it as my function return value.

Is there a way to do this then be able to do a select b for a=1 from this table ???

The tricky part is not having to create a physical table. One can think of using THE, CAST, TABLE, ... but I don't want to have to create a nested table and store it somewhere since this defeats the initial purpose.

Thanks in advance.

Sam Habbab Received on Mon Jul 10 2000 - 00:00:00 CDT