Issue Details (XML | Word | Printable)

Key: DOC-29
Type: Improvement Improvement
Status: Closed Closed
Resolution: Won't Fix
Priority: Minor Minor
Assignee: Helen Borrie
Reporter: Ain Valtin
Votes: 0
Watchers: 0
Operations

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

Bad example code for SP default parameters

Created: 09/May/08 08:45 AM   Updated: 25/Dec/08 07:49 PM
Component/s: None
Affects Version/s: None
Fix Version/s: None

Time Tracking:
Not Specified


 Description  « Hide
In FB 2.1 release notes, in chapter "Defaults for Stored Procedure Arguments" the example creates selectable stored procedure (named P1) and then executes it (ie EXECUTE PROCEDURE P1). Executing selectable SP isn't allowed (?) and thus the example is incorrect (or at least bad style).

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Helen Borrie added a comment - 25/Dec/08 07:47 PM
The OP is correct: this is not an example of sound PSQL programming practice. However, it should be obvious that the author used it in the examples to illustrate the working of the new feature. A comment was added to the article in the release notes.

Helen Borrie added a comment - 25/Dec/08 07:48 PM
But added a note that using SUSPEND in an executable SP is not recommended practice.