Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group