Sample Header Ad - 728x90

Array of strings when updating a field

2 votes
1 answer
8537 views
Unintentionally discovered that following query works in PostgreSQL: UPDATE "sometable" SET "somefield" = ('string1', 'string2') WHERE "id" = 1; I'm passing an array of strings to field and the result is a string of '("string1","string2")', not an array as expected, at least then using php extension pgsql. How this happens and that does ('string1', 'string2') means in PostgreSQL? I don't think this works in other SQL RDBMSes.
Asked by happy_marmoset (539 rep)
Sep 9, 2015, 09:11 AM
Last activity: May 6, 2024, 02:01 AM