Why is the first commaa wrong? I guess thats my question how do I set a value of a type to null? I mean if type is made up of type a,b,c how do I set them all at once, but having b to be null? I thought using the ,, with nothing in between would do that I guess I was wrong. Any help would be much appreciated. -assad On 1/9/06, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Assad Jarrahian <jarraa@xxxxxxxxx> writes: > > UPDATE userprofiles SET address = ROW( > > ,'','','',,'',,'','','','','','','','','','') where > > username='mooreg3'; > > > ERROR: syntax error at or near "," at character 41 > > That first comma is wrong, or else you forgot to put in a value > before it ... > > regards, tom lane >
