Home A - Z
Page Index

An Otter Wiki

Commit 0d9f64

2026-03-18 03:24:01 German Gamboa: -/-
sql/general notes.md ..
@@ 7,10 7,9 @@
## unnest is pretty cool for inserting multiple rows:
```sql
- INSERT INTO table_name (col1, col2, col3)
- SELECT * FROM UNNEST(
- ARRAY['val1', 'val2', 'val3'],
- ARRAY['val4', 'val5', 'val6'],
- ARRAY[1, 2, 3]
- );
+ INSERT INTO table_name (col1, col2, col3)
+ SELECT * FROM UNNEST(
+ ARRAY['val1', 'val2', 'val3'],
+ ARRAY['val4', 'val5', 'val6'],
+ ARRAY[1, 2, 3]);
```
0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9