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

Support fuction [CORE3162] #3538

Closed
firebird-automations opened this issue Oct 5, 2010 · 8 comments
Closed

Support fuction [CORE3162] #3538

firebird-automations opened this issue Oct 5, 2010 · 8 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Ivan (patuljak)

Duplicates CORE1326

oracle has function which we use with sql agg function.

example.

create or replace FUNCTION my_function(@id number) return number is
my_out number;

begin

select sum(price) into my_out from finance where Itable.ID=@id;

return my_out;
end my_out;

select *,my_function(ID) sum from products

why do need this? because, we can do many things with this and function is necessary in firebird.

@firebird-automations
Copy link
Collaborator Author

Modified by: Ivan (patuljak)

description: oracle has function which we use with sql agg function.

example.

create or replace FUNCTION my_function(@id number) return number is
my_out number;

begin

select sum(price) into my_out from finance where Itable.ID=@id;

return my_out;
end my_out;

select *,my_function(ID) sum from products
why do need this? because, we can do many things with this and function is necessary in firebird.

=>

oracle has function which we use with sql agg function.

example.

create or replace FUNCTION my_function(@id number) return number is
my_out number;

begin

select sum(price) into my_out from finance where Itable.ID=@id;

return my_out;
end my_out;

select *,my_function(ID) sum from products

why do need this? because, we can do many things with this and function is necessary in firebird.

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

This is not Oracle syntax.

Oracle support user defined aggregate functions, but it's not very simple. It's related to they ODCI interfaces.

Aggregate UDF is already requested in CORE1326.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Link: This issue duplicates CORE1326 [ CORE1326 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Ivan (patuljak)

I think on true function, not udf or odci.

and this function no connection with udf.

@firebird-automations
Copy link
Collaborator Author

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

This is simple function, Firebird 3 already supports it.

When you hear UDF, please understand it as all kind of functions defined by the user: PSQL, C, Java, etc.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant