|Subject||Re: Domains and NOT NULL in PSQL|
> Based on past discussions I've done a prototype implementationallowing
> domains and NOT NULL to be used in PSQL.Oracle also permit to specify a table.column as datatype.
> See that as another call for discussion on the topic.
Syntax is somewhat clunsky:
The advantage here is to have the same type as the field you're using.
Although there are a dependency between the table and the procedure,
changing one, will directly invalidate other.
Maybe the change should restrict for column and don't for domains in
declare my_var type of column table.column;