Thread: Re: Update statement doesn't work
David Johnston wrote > > 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. Note "pgAdmin" is an unusual place to put this question; just because you use pgAdmin doesn't mean it is the problem. -novice or -general would be a better place to ask this (probably -novice considering). Also, the query you got the error on does not match the query you supplied. Namely you did NOT use double-quote around the word "Name" but simply did: UPDATE "Category" SET Name = 'test' .... Because the name column is not quoted it automatically becomes lower-case and so is equivalent to: UPDATE "Category" SET name = 'test' ... and if indeed the column is called "Name" it would not be found when searching for /name/ David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Update-statement-doesn-t-work-tp5770031p5770040.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
thanks it worked :) -- View this message in context: http://postgresql.1045698.n5.nabble.com/Update-statement-doesn-t-work-tp5770031p5770068.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.