I'm passing an array of strings ...
You are not passing an array, at least not a Postgres array type.
An array literal would look like this:
You can type it explicitly:
The same can be achieved with an ARRAY constructor in most places:
This is constructing a row (of type "anonymous record"):
It's short syntax for a ROW constructor:
And can, in similar fashion be provided as string literal (row literal) as well:
Each of those anonymous records can be cast to a well know row type:
UPDATE statement Postgres coerces the value to the data type of the target column or raises an exception if that cannot be done. If
sometable.somefield is data type
text, the text representation of the above row is saved, which is
'("string1","string2")'. Double quotes are only added where necessary to keep the syntax unambiguous.