Let’s create our table as above.<\/p>\n
Let’s note that there is a [ ] bracket sign at the end of the second and third column.<\/p>\n
These are necessary for us to insert in array format.<\/p>\n
We can insert our data in several ways.<\/p>\n
INSERT INTO sal_emp\r\n VALUES ('Bill',\r\n '{10000, 10000, 10000, 10000}',\r\n '{{\"meeting\", \"lunch\"}, {\"training\", \"presentation\"}}');<\/pre>\nSecondly, we can perform the insert operation using the ARRAY command as follows.<\/p>\n
INSERT INTO sal_emp\r\n VALUES ('Ahmet',\r\n ARRAY[12000, 13000, 14000, 15000],\r\n ARRAY[['meeting', 'lunch'], ['training', 'presentation']]);\r\n\tINSERT INTO sal_emp\r\n VALUES ('Carol',\r\n ARRAY[20000, 25000, 25000, 25000],\r\n ARRAY[['breakfast', 'consulting'], ['meeting', 'lunch']]);<\/pre>\nWe inserted our data and let’s make our query.<\/p>\n
select schedule[1:1] from sal_emp where name='Carol' ;<\/pre>\n![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/array1.png\")
<\/p>\n
Let’s reinforce it with another example.<\/p>\n
select pay_by_quarter[1] from sal_emp where name='Carol' ;<\/pre>\n![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/array2.png\")
<\/p>\n
<\/div>\n