Issue Details (XML | Word | Printable)

Key: CORE-1976
Type: Improvement Improvement
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Alexander Tyutik
Votes: 0
Watchers: 2
Operations

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

Default values for procedure

Created: 04/Jul/08 03:49 AM   Updated: 18/Feb/09 02:33 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: None


 Description  « Hide
I have many procedures with many parameters with default values. It would be nice to have ability to omit any default parameter, not only last.
I have 2 solutions:

CREATE PROCEDURE PROC (
  PARAM_A INTEGER,
  PARAM_B INTEGER = 2,
  PARAM_C INTEGER = 3
) ...



1) Use empty parameters or DEFAULT keyword:

SELECT * FROM PROC(1, , 5) or SELECT * FROM PROC(1, DEFAULT, 5)



2) Use named parameters (always in the end of list):

SELECT * FROM PROC(1, ?PARAM_C = 5) or SELECT * FROM PROC(?PARAM_A = 1, ?PARAM_C = 5)

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.