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