Re: [GENERAL] userdefined types

2006-01-09 Thread Tino Wildenhain
Assad Jarrahian schrieb: > 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

Re: [GENERAL] userdefined types

2006-01-09 Thread Assad Jarrahian
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

Re: [GENERAL] userdefined types

2006-01-09 Thread Tom Lane
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 ...

Re: [GENERAL] userdefined types

2006-01-08 Thread Assad Jarrahian
C code (I am confused, are you talking about c-functions and types, cause I don't have any!) all I have is listed below (with the last query not working) So getting back to user-defined types, is it REALLY necessary to have the in-out functions (just to note, I am using jdbc with the db) Thanks!

Re: [GENERAL] userdefined types

2006-01-08 Thread Tom Lane
Assad Jarrahian <[EMAIL PROTECTED]> writes: > it does not like the commas one after the other (empty value) how > do I solve that or does this have something to do with those two > methods (in and out) that I overlooked. > any insight would be much appreciated. You have not given us nea