Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

TYPE OF COLUMN in PSQL [CORE1356] #1774

Closed
firebird-automations opened this issue Jul 14, 2007 · 16 comments
Closed

TYPE OF COLUMN in PSQL [CORE1356] #1774

firebird-automations opened this issue Jul 14, 2007 · 16 comments

Comments

@firebird-automations
Copy link
Collaborator

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
Copy link
Collaborator Author

Modified by: @cincuranet

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @cincuranet

Good to hear this.

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Beta 2 [ 10190 ]

@firebird-automations
Copy link
Collaborator Author

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
Copy link
Collaborator Author

Modified by: @asfernandes

Fix Version: 2.1 Beta 2 [ 10190 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Fix Version: 2.5 Alpha 1 [ 10224 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA300 [ QA300 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants