Martijn Tonies wrote:

>> So I propose we defer variables/parameters constraints to first read,
>> but of course checking in assignments too.
>>
>
> Sounds very logical.
>
>
>> So you'll get an error if you read a not-nullable variable/parameter
>> that is null or try to assign null to it, but don't get error if you
>> declare and not use it.
>>
>
> Sounds fair to me.
>
>
>> For output parameters, you get error if you try to exit/suspend the
>> procedure with nulls on output parameters.
>>
>> Comments?
>>
>
> Question: this is for the true usage of domains in PSQL then?
>

Yes, constraints and default is what are missing.

> If so: good job!
>

Thanks. :-)


Adriano