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

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

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

 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   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.