Обсуждение: bug: 2 dimensional array

Поиск
Список
Период
Сортировка

bug: 2 dimensional array

От
Kathy zhu
Дата:
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.