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
Last activity: May 6, 2024, 02:01 AM