Re: userdefined types - Mailing list pgsql-general

From Assad Jarrahian
Subject Re: userdefined types
Date
Msg-id 4bd3e1480601091030j2a3cc0abk4f6f30eb0ab64c7c@mail.gmail.com
Whole thread Raw
In response to Re: userdefined types  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: userdefined types  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
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@sss.pgh.pa.us> wrote:
> Assad Jarrahian <jarraa@gmail.com> 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
>

pgsql-general by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Drop user doesn't drop granted privs?
Next
From: Tino Wildenhain
Date:
Subject: Re: userdefined types