Arrays as Columns

Hi,

I would like to use an array as a column in a table. Something like:

CREATE TYPE MYARRAYTYPE VARRAY(15); CREATE TABLE MYTABLE (
...
MYARRAY MYARRAYTYPE,
)

The problem is, I want MYARRAY to be part of the primary key. Is there any way to do this. Also, is there an easy to to use MYARRAY in a WHERE clause by saying 'WHERE MYARRAY = ARRAY_IN' or 'MYARRAY = MYFUNC(ARRAY_IN)'? Thanks,
Salaam Yitbarek

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 14 1999 - 23:15:29 CDT