Thread: Re: Update statement doesn't work

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.