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

Jump to bottom

Allow using RDB$GET_CONTEXT for default value of field [CORE3463] #3824

Open
firebird-automations opened this issue May 5, 2011 · 2 comments
Open

Allow using RDB$GET_CONTEXT for default value of field [CORE3463] #3824

firebird-automations opened this issue May 5, 2011 · 2 comments
Labels
component: engine priority: minor type: improvement

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Maxim Kuzmin (cybermax)

Votes: 2

Example:
ALTER TABLE TABLE1 ALTER ID_CREATOR SET DEFAULT RDB$GET_CONTEXT ('USER_SESSION', 'ID_USER')
@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Have you tried:
ALTER TABLE TABLE1 ALTER ID_CREATOR SET DEFAULT (SELECT RDB$GET_CONTEXT ('USER_SESSION', 'ID_USER') FROM RDB$Database)

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

I believe we can allow all built-in functions as default values.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
component: engine priority: minor type: improvement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@firebird-automations