Mega Code Archive

 

Categories / PostgreSQL / Array

 

Use array constant in select statement

postgres=# postgres=# SELECT ARRAY[1,2,3+4];   array ---------  {1,2,7} (1 row)