bug: 2 dimensional array

From: Kathy zhu <Kathy(dot)zhu(at)Sun(dot)COM>
To: pgsql-bugs(at)postgresql(dot)org
Subject: bug: 2 dimensional array
Date: 2002-07-26 18:02:00
Message-ID: 3D418E98.C5722C08@Sun.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2002-07-27 01:36:07 Bug #722: SELECT FOR UPDATE bug
Previous Message Kathy zhu 2002-07-26 18:00:01 bug "\! cd"