postgresql: when to use array constructor vs curly brackets

Question

I am trying understand why this is a syntax error:

SELECT distinct precinct FROM ballots
WHERE code_string = ANY (
  { '20000420300098', '20001240300074'})

While this succeeds?

SELECT distinct precinct FROM ballots
WHERE code_string = ANY (
  ARRAY[ '20000420300098', '20001240300074'])

Ry- · Accepted Answer · 2017-10-15 03:17:18Z

8

Curly braces are used in the text representation of arrays.

SELECT distinct precinct FROM ballots
WHERE code_string = ANY (
  '{20000420300098,20001240300074}')

answered Oct 15, 2017 at 3:17

Ry-♦

226k56 gold badges496 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1