syntax prob
От | postgresql |
---|---|
Тема | syntax prob |
Дата | |
Msg-id | 200102240217.f1O2Hhx35303@mail.postgresql.org обсуждение исходный текст |
Ответы |
Re: syntax prob
|
Список | pgsql-sql |
I am away from my server for the weekend and I need a little help. when doing updates of multiple fields there commas between the elements? I mean update table set cname = 'Bill', caddress = '2nd floor' where acode = 'AVAN'; I refer to the space between 'Bill' and caddress. if I could get to the server I would just try it. what happens if you have only 1 field to update and you add a comma, like this update table set cname = 'Bill', where acode = 'AVAN'; I am trying to concatenate an update string and I would love to not have to worry about the comma. I guess I could figure out how many things have changed then add commas... but I could also wish for it to be easier. Ted
В списке pgsql-sql по дате отправления: