ARRAY_SORT
Last updated: 01/09/2026Retorna os valores da matriz em ordem crescente.
Sintaxe
ARRAY_SORT(array)
Argumentos
array
Tipo: qualquer
Uma matriz de qualquer tipo de valor.
Retorna
Tipo: o mesmo que a entrada, mas em ordem crescente.
Exemplos
| array | Saída |
|---|---|
| [2, 1, 3] | [1, 2, 3] |
| ["b", "a", "cd", "cc"] | ["a", "b", "cc", "cd"] |
| [0.5, 1.0, 0.75, 1.5] | [0.5, 0.75, 1.0, 1.5] |
| null::string | nulo |
| [true, false, true] | [false, true, true] |
| [date "2023-04-01", date "2023-04-01", date "2023-05-02"] | [date "2023-04-01", date "2023-04-01", date "2023-05-02"] |
| [timestamp "2023-01-02 11:00:00", timestamp "2023-01-01 09:00:00", timestamp "2023-01-01 10:00:00"] | [timestamp "2023-01-01 09:00:00", timestamp "2023-01-01 10:00:00", timestamp "2023-01-02 11:00:00"] |