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 <[EMAIL PROTECTED]> wrote:
> Assad Jarrahian <[EMAIL PROTECTED]> 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
>
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
