Posts by rbrt • 1 point

• 0

  votes

  1

  answer

  186

  views

  A: Check Array(STRING) in Postgres column

  I got through the following way: update tabelaTeste SET versao = '2' WHERE conta = ANY(['1','3','4'])

  sql postgresql postgresql-10

  answered 4 years, 7 months ago rbrt 1

• -2

  votes

  1

  answer

  186

  views

  Q: Check Array(STRING) in Postgres column

  Good afternoon, everyone, I need to UPDATE a table, but for this I need to compare if the values of an ARRAY(STRING) are inside a column of this table, example: UPDATE tabelaTeste SET versao = '2'…

  sql postgresql postgresql-10

  asked 4 years, 7 months ago rbrt 1