TYPE OF COLUMN in PSQL [CORE1356]

[firebird-automations]

Submitted by: @cincuranet

Is related to QA300

Oracle has nice feature that you can use use '%type' to specify type of parameter in procedure. For example:
id_ticket http://ticket.id%type;

so it's easy to use same type in procedure as in table. I know, we have now domains in procedures, but not everytime you create domain for column.

[firebird-automations]

Modified by: @cincuranet

summary: Oracle's %type for procedures => Oracle's '%type' for procedures

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Commented by: @asfernandes

I already started work on this and will propose in fb-architect soon.

[firebird-automations]

Commented by: @cincuranet

Good to hear this.

[firebird-automations]

Commented by: @asfernandes

Syntax: TYPE OF COLUMN <table or view name>.<column name>

[firebird-automations]

Modified by: @asfernandes

issuetype: Improvement [ 4 ] => New Feature [ 2 ]

summary: Oracle's '%type' for procedures => TYPE OF COLUMN in PSQL

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

[firebird-automations]

Modified by: @pcisar

Fix Version: 2.1 Beta 2 [ 10190 ]

[firebird-automations]

Commented by: @asfernandes

No, Pavel, this is not Beta2.

This is B3_0_Transition branch, and it requires ODS change, so it will be in next major release.

But since I don't know if we'll have a major release before V3, I didn't marked the fix version.

[firebird-automations]

Modified by: @asfernandes

Fix Version: 2.1 Beta 2 [ 10190 ] =>

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 12580 ] => Firebird [ 14200 ]

[firebird-automations]

Modified by: @asfernandes

Fix Version: 2.5 Alpha 1 [ 10224 ]

[firebird-automations]

Commented by: @asfernandes

Documentation is in doc/sql.extensions/README.column_type_psql.txt

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA300 [ QA300 ]

[firebird-automations]

Modified by: @pmakowski

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done successfully