PostgreSQL 8.4 Documentationspecification might be necessary.) Now we can show some INSERT statements: INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"training", "presentation"}}’); INSERT pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,10000,10000,10000} | {{meeting,lunch},{training,presentation}} Carol | {20000,25000,25000 extents for each dimension. A mismatch causes an error, for example: INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"meeting"}}’); ERROR: multidimensional0 码力 | 2224 页 | 5.05 MB | 1 年前3- PostgreSQL 8.4 Documentationspecification might be necessary.) Now we can show some INSERT statements: INSERT INTO sal_emp VALUES (’Bill’, 138 Chapter 8. Data Types ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"training" pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,10000,10000,10000} | {{meeting,lunch},{training,presentation}} Carol | {20000,25000,25000 extents for each dimension. A mismatch causes an error, for example: INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"meeting"}}’); ERROR: multidimensional0 码力 | 2371 页 | 5.09 MB | 1 年前3
- PostgreSQL 9.0 Documentationspecification might be necessary.) Now we can show some INSERT statements: INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"training", "presentation"}}’); INSERT pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,10000,10000,10000} | {{meeting,lunch},{training,presentation}} Carol | {20000,25000,25000 extents for each dimension. A mismatch causes an error, for example: INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"meeting"}}’); ERROR: multidimensional0 码力 | 2561 页 | 5.55 MB | 1 年前3
- PostgreSQL 9.0 Documentationspecification might be necessary.) Now we can show some INSERT statements: INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"training", "presentation"}}’); INSERT pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,10000,10000,10000} | {{meeting,lunch},{training,presentation}} Carol | {20000,25000,25000 extents for each dimension. A mismatch causes an error, for example: INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"meeting"}}’); ERROR: multidimensional0 码力 | 2401 页 | 5.50 MB | 1 年前3
- PostgreSQL 8.0 Documentationspecification might be necessary.) Now we can show some INSERT statements. INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"meeting"}}’); ERROR: multidimensional matching extents for each dimension. A mismatch causes an error report. INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"training", "presentation"}}’); INSERT pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,10000,10000,10000} | {{meeting,lunch},{training,presentation}} Carol | {20000,25000,250000 码力 | 1422 页 | 9.92 MB | 1 年前3
- PostgreSQL 8.0 Documentationspecification might be necessary.) Now we can show some INSERT statements. INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"meeting"}}’); ERROR: multidimensional matching extents for each dimension. A mismatch causes an error report. INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"training", "presentation"}}’); INSERT pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,10000,10000,10000} | {{meeting,lunch},{training,presentation}} Carol | {20000,25000,250000 码力 | 1332 页 | 9.76 MB | 1 年前3
- PostgreSQL 9.1.24 Documentation
specification might be necessary.) Now we can show some INSERT statements: INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"training", "presentation"}}’); INSERT pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,10000,10000,10000} | {{meeting,lunch},{training,presentation}} Carol | {20000,25000,25000 extents for each dimension. A mismatch causes an error, for example: INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"meeting"}}’); ERROR: multidimensional0 码力 | 2667 页 | 6.57 MB | 1 年前3
- PostgreSQL 9.1 Documentationspecification might be necessary.) Now we can show some INSERT statements: INSERT INTO sal_emp VALUES (’Bill’, 150 Chapter 8. Data Types ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"training" pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,10000,10000,10000} | {{meeting,lunch},{training,presentation}} Carol | {20000,25000,25000 extents for each dimension. A mismatch causes an error, for example: INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"meeting"}}’); ERROR: multidimensional0 码力 | 2836 页 | 6.62 MB | 1 年前3
- PostgreSQL 8.1.11 Documentationspecification might be necessary.) Now we can show some INSERT statements. INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"meeting"}}’); ERROR: multidimensional matching extents for each dimension. A mismatch causes an error report. INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"training", "presentation"}}’); INSERT pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,10000,10000,10000} | {{meeting,lunch},{training,presentation}} Carol | {20000,25000,250000 码力 | 1582 页 | 12.19 MB | 1 年前3
- PostgreSQL 8.1 Documentationspecification might be necessary.) Now we can show some INSERT statements. INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"meeting"}}’); ERROR: multidimensional matching extents for each dimension. A mismatch causes an error report. INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, ’{{"meeting", "lunch"}, {"training", "presentation"}}’); INSERT pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,10000,10000,10000} | {{meeting,lunch},{training,presentation}} 112 Chapter 8. Data Types0 码力 | 1548 页 | 11.54 MB | 1 年前3
共 40 条
- 1
- 2
- 3
- 4