Mohamedyousof wrote
> UPDATE "Categories" SET ("Name") = ('test') where "ID" = 28;No parenthesis: UPDATE "Categories" SET "Name" = 'test' WHERE "ID" = 28; This presumes you truly need the double-quotes. It this does not work try removing the double-quotes around "Categories", "Name" and "ID" and see what happens. I am curious why you think the parentheses are necessary. Something in the PostgreSQL documentation you've misread; it works (for some reason) elsewhere so you simply tried it here as well; or you learned (or just guessed) at the syntax incorrectly from some other source? David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Update-statement-doesn-t-work-tp5770031p5770039.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
