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
Comments
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 begin select sum(price) into my_out from finance where Itable.ID=@id; return my_out; select *,my_function(ID) sum from products => oracle has function which we use with sql agg function. example. create or replace FUNCTION my_function(@id number) return number is begin select sum(price) into my_out from finance where Itable.ID=@id; return 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. |
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. |
Modified by: @asfernandes |
Commented by: Ivan (patuljak) I think on true function, not udf or odci. and this function no connection with udf. |
Commented by: Ivan (patuljak) http://www.java2s.com/Tutorial/Oracle/0540__Function-Procedure-Packages/Createasimplefunction.htm |
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. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
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.
The text was updated successfully, but these errors were encountered: