PostgreSQL 8.1.11 Documentationarray types, we create this table: CREATE TABLE sal_emp ( name text, pay_by_quarter integer[], schedule text[][] ); As shown, an array data type is named by appending square brackets ([]) to the data the employee’s salary by quarter, and a two-dimensional array of text (schedule), which represents the employee’s weekly schedule. The syntax for CREATE TABLE allows the exact size of arrays to be specified result of the previous two inserts looks like this: SELECT * FROM sal_emp; name | pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,100000 码力 | 1582 页 | 12.19 MB | 1 年前3- PostgreSQL 8.1 Documentationarray types, we create this table: CREATE TABLE sal_emp ( name text, pay_by_quarter integer[], schedule text[][] ); As shown, an array data type is named by appending square brackets ([]) to the data the employee’s salary by quarter, and a two-dimensional array of text (schedule), which represents the employee’s weekly schedule. The syntax for CREATE TABLE allows the exact size of arrays to be specified result of the previous two inserts looks like this: SELECT * FROM sal_emp; name | pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,100000 码力 | 1548 页 | 11.54 MB | 1 年前3
- PostgreSQL 9.6.24 Documentationarray types, we create this table: CREATE TABLE sal_emp ( name text, pay_by_quarter integer[], schedule text[][] ); As shown, an array data type is named by appending square brackets ([]) to the data the employee’s salary by quarter, and a two-dimensional array of text (schedule), which represents the employee’s weekly schedule. The syntax for CREATE TABLE allows the exact size of arrays to be specified result of the previous two inserts looks like this: SELECT * FROM sal_emp; name | pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,100000 码力 | 2814 页 | 6.58 MB | 1 年前3
- PostgreSQL 9.6.24 Documentation
array types, we create this table: CREATE TABLE sal_emp ( name text, pay_by_quarter integer[], schedule text[][] ); As shown, an array data type is named by appending square brackets ([]) to the data the employee’s salary by quarter, and a two-dimensional array of text (schedule), which represents the employee’s weekly schedule. The syntax for CREATE TABLE allows the exact size of arrays to be specified result of the previous two inserts looks like this: SELECT * FROM sal_emp; name | pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,100000 码力 | 2661 页 | 6.53 MB | 1 年前3
- PostgreSQL 9.5.25 Documentation
array types, we create this table: CREATE TABLE sal_emp ( name text, pay_by_quarter integer[], schedule text[][] ); As shown, an array data type is named by appending square brackets ([]) to the data the employee’s salary by quarter, and a two-dimensional array of text (schedule), which represents the employee’s weekly schedule. The syntax for CREATE TABLE allows the exact size of arrays to be specified result of the previous two inserts looks like this: SELECT * FROM sal_emp; name | pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,100000 码力 | 2558 页 | 6.27 MB | 1 年前3
- PostgreSQL 9.5 Documentationarray types, we create this table: CREATE TABLE sal_emp ( name text, pay_by_quarter integer[], schedule text[][] ); As shown, an array data type is named by appending square brackets ([]) to the data the employee’s salary by quarter, and a two-dimensional array of text (schedule), which represents the employee’s weekly schedule. The syntax for CREATE TABLE allows the exact size of arrays to be specified result of the previous two inserts looks like this: SELECT * FROM sal_emp; name | pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,100000 码力 | 2714 页 | 6.33 MB | 1 年前3
- PostgreSQL 10.23 Documentationthis table: CREATE TABLE sal_emp ( name text, pay_by_quarter integer[], schedule text[][] ); As shown, an array data type is named by appending square brackets ([]) to the the employee's salary by quarter, and a two-dimensional array of text (schedule), which repre- sents the employee's weekly schedule. The syntax for CREATE TABLE allows the exact size of arrays to be specified inserts looks like this: SELECT * FROM sal_emp; name | pay_by_quarter | schedule -------+--------------------------- +------------------------------------------- Bill | {100000 码力 | 2590 页 | 12.03 MB | 1 年前3
- PostgreSQL 10.23 Documentationthis table: CREATE TABLE sal_emp ( name text, pay_by_quarter integer[], schedule text[][] ); As shown, an array data type is named by appending square brackets ([]) to the the employee's salary by quarter, and a two-dimensional array of text (schedule), which represents the employee's weekly schedule. The syntax for CREATE TABLE allows the exact size of arrays to be specified inserts looks like this: SELECT * FROM sal_emp; name | pay_by_quarter | schedule -------+--------------------------- +------------------------------------------- Bill | {100000 码力 | 2727 页 | 11.93 MB | 1 年前3
- PostgreSQL 9.4 Documentationarray types, we create this table: CREATE TABLE sal_emp ( name text, pay_by_quarter integer[], schedule text[][] ); As shown, an array data type is named by appending square brackets ([]) to the data the employee’s salary by quarter, and a two-dimensional array of text (schedule), which represents the employee’s weekly schedule. The syntax for CREATE TABLE allows the exact size of arrays to be specified result of the previous two inserts looks like this: SELECT * FROM sal_emp; name | pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,100000 码力 | 2603 页 | 6.05 MB | 1 年前3
- PostgreSQL 9.4.26 Documentation
array types, we create this table: CREATE TABLE sal_emp ( name text, pay_by_quarter integer[], schedule text[][] ); As shown, an array data type is named by appending square brackets ([]) to the data the employee’s salary by quarter, and a two-dimensional array of text (schedule), which represents the employee’s weekly schedule. The syntax for CREATE TABLE allows the exact size of arrays to be specified result of the previous two inserts looks like this: SELECT * FROM sal_emp; name | pay_by_quarter | schedule -------+---------------------------+------------------------------------------- Bill | {10000,100000 码力 | 2452 页 | 5.99 MB | 1 年前3
共 40 条
- 1
- 2
- 3
- 4