Re: [SQL] syntax prob

2001-02-24 Thread Tod McQuillin
On Fri, 23 Feb 2001, postgresql wrote: > when doing updates of multiple fields there commas between > the elements? Yes. update t set a=b, c=d where ... > 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 > > up

[SQL] syntax prob

2001-02-23 Thread postgresql
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 g