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 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
PostgreSQL 8.2 Documentationspecification might be necessary.) Now we can show some INSERT statements. INSERT INTO sal_emp VALUES (’Bill’, ’{10000, 10000, 10000, 10000}’, 115 Chapter 8. Data Types ’{{"meeting", "lunch"}, {"training" pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,10000,10000,10000} | {{meeting,lunch},{training,presentation}} Carol | {20000,25000,25000 {meeting,lunch}} (2 rows) The ARRAY constructor syntax may also be used: INSERT INTO sal_emp VALUES (’Bill’, ARRAY[10000, 10000, 10000, 10000], ARRAY[[’meeting’, ’lunch’], [’training’, ’presentation’]]);0 码力 | 1762 页 | 5.43 MB | 1 年前3
PostgreSQL 8.2 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 {meeting,lunch}} (2 rows) The ARRAY constructor syntax may also be used: INSERT INTO sal_emp VALUES (’Bill’, ARRAY[10000, 10000, 10000, 10000], ARRAY[[’meeting’, ’lunch’], [’training’, ’presentation’]]);0 码力 | 1748 页 | 13.12 MB | 1 年前3
PostgreSQL 8.3 DocumentationNow we can show some INSERT statements: 124 Chapter 8. Data Types 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 {meeting,lunch}} (2 rows) The ARRAY constructor syntax can also be used: INSERT INTO sal_emp VALUES (’Bill’, ARRAY[10000, 10000, 10000, 10000], ARRAY[[’meeting’, ’lunch’], [’training’, ’presentation’]]);0 码力 | 2143 页 | 4.58 MB | 1 年前3
PostgreSQL 8.3 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 {meeting,lunch}} (2 rows) The ARRAY constructor syntax can also be used: INSERT INTO sal_emp VALUES (’Bill’, ARRAY[10000, 10000, 10000, 10000], ARRAY[[’meeting’, ’lunch’], [’training’, ’presentation’]]);0 码力 | 2015 页 | 4.54 MB | 1 年前3
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
共 40 条
- 1
- 2
- 3
- 4













