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.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to