bug: 2 dimensional array

Started by Kathy Zhuover 23 years ago1 messagesbugs
Jump to latest
#1Kathy Zhu
Kathy.Zhu@Sun.COM

Here is the sequence suggested in the Tutorial from your site:

CREATE TABLE SAL_EMP (
kathydb(# name text,
pkathydb(# ay_by_quarter integer[],
schedule kathydb(# text[][]
);

INSERT INTO SAL_EMP
VAkathydb-# LUES ('Bill',
kathydb(# '{10000, 10000, 10000, 10000}',
'kathydb(# {{"meeting", "lunch"}, {}}');

select * from sal_emp;
name | pay_by_quarter | schedule
------+---------------------------+--------------------
Bill | {10000,10000,10000,10000} | {{"meeting"},{""}}
(1 row)

**** bug:
"Lunch" is gone.