Re: [GENERAL] How to use record variable with non-null domain in plpgsql

2015-08-22 Thread Andrus
Hi! TBH, the problem here is with the not-null constraint on the domain. Get rid of that and you'll be much happier. Is the only reasonable way is to change domain using ALTER DOMAIN tebool DROP NOT NULL ? bool types of columns are never used in database. Instead of them tebool type

Re: [GENERAL] How to use record variable with non-null domain in plpgsql

2015-08-22 Thread Tom Lane
"Andrus" writes: > I'm looging for a way to use tebool type records in plpgsql method starting > from Postgres 9.1 > I tried code below but got error > domain tebool does not allow null values > Domain tebool default value is false so plpgsql must assing false to it and > should not throw error

[GENERAL] How to use record variable with non-null domain in plpgsql

2015-08-22 Thread Andrus
I'm looging for a way to use tebool type records in plpgsql method starting from Postgres 9.1 I tried code below but got error domain tebool does not allow null values Domain tebool default value is false so plpgsql must assing false to it and should not throw error. How to fix this so that su