Issue Details (XML | Word | Printable)

Key: CORE-1356
Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Adriano dos Santos Fernandes
Reporter: Jiri Cincura
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

TYPE OF COLUMN in PSQL

Created: 14/Jul/07 06:06 PM   Updated: 22/Jun/11 03:53 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 2.5 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
Oracle has nice feature that you can use use '%type' to specify type of parameter in procedure. For example:
id_ticket 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.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes added a comment - 14/Jul/07 08:11 PM
I already started work on this and will propose in fb-architect soon.

Jiri Cincura added a comment - 15/Jul/07 04:42 AM
Good to hear this.

Adriano dos Santos Fernandes added a comment - 16/Aug/07 11:22 AM
Syntax: TYPE OF COLUMN <table or view name>.<column name>

Adriano dos Santos Fernandes added a comment - 16/Aug/07 11:59 AM
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.

Adriano dos Santos Fernandes added a comment - 09/May/08 11:31 AM
Documentation is in doc/sql.extensions/README.column_type_psql.txt