Skip site navigation (1) Skip section navigation (2)

Re: userdefined types

From: Assad Jarrahian <jarraa(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: userdefined types
Date: 2006-01-09 18:30:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.

On 1/9/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Assad Jarrahian <jarraa(at)gmail(dot)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

In response to


pgsql-general by date

Next:From: Tino WildenhainDate: 2006-01-09 19:00:21
Subject: Re: userdefined types
Previous:From: Emi LuDate: 2006-01-09 16:39:09
Subject: Vacuum all tables unders under one schema (not under one database)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group