Subject | Re: [Firebird-Architect] PSQL type based on column type |
---|---|
Author | Alex Peshkov |
Post date | 2007-07-17T08:40:42Z |
On Tuesday 17 July 2007 02:19, Adriano dos Santos Fernandes wrote:
> I suggest we use syntax "column table.column", that is also consistentLooks good for me, but for the future, not for 2.1.
> with syntax for COMMENT ON COLUMN, example:
> declare name1 type of column employee.name
> declare name2 column employee.name
> cast(name as type of column employee.name)
> cast(name as column employee.name)
>
>
> Implementation:
>
> Add columns RDB$RELATION_NAME and RDB$FIELD_NAME to
> RDB$PROCEDURE_PARAMETERS.
>
> When type of a column (RDB$RELATION_FIELDS.RDB$FIELD_SOURCE) is changed,
> the change is propagated to RDB$PROCEDURE_PARAMETERS.RDB$FIELD_SOURCE
> using this information.
>
> Create a new verb blr_column_name (constrained/type of, table name,
> column name), with same semantics of blr_domain_name.
>
> All logic of domain type change is extended to column type change, i.e.,
> to invalidate/recompile procedures and triggers.
>
> Comments?