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
Aggregate UDF [CORE1326] #1745
Comments
Modified by: @pcisarWorkflow: jira [ 12350 ] => Firebird [ 14884 ] |
Commented by: Ivan (patuljak) mysql support this and maybe other databases. why is this important? if I need functions which contains few aggregate function then the best way for this problem is aggregate UDF. firebird c-api does not support this and I don't know why? many special functions which people need can't be write in sql query. for example consider standard deviation http://en.wikipedia.org/wiki/Standard_deviation first query is avg(x) on stored procedures. then I know that somebody will say that database is not for processing data. cursor is very slow, ETL (SISS) is fast but for processing data is slow. application for statistics is also not very good. what users want is only enable aggregate UDF in c-api and nothing else. |
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandes |
Commented by: adnanoncevarlik (adnanoncevarlik) Hi All, May be wrong place to say but we want to create functions on FIREBIRD and want to use in SELECT statements. Like this, CREATE MY_FUNC_CALC_AGE(prmBirthDay TIMESTAMP) RETURNS RET_AGE INTEGER SELECT NAME, SIRNAME, MY_FUNC_CALC_AGE( BIRTHDAY) When this issue will planned to solve ? Thank you and best regards |
Commented by: @dyemanov It's implemented in FB v3.0. |
Commented by: Mason Wheeler (masonwheeler) Is there any documentation available on this, as to how one would go about creating an external aggregate function in FB 3.0? |
Commented by: @asfernandes It's simple PSQL functions which is implemented. Aggregate function is not nor will be in FB 3.0. |
Commented by: Juan Antonio Castillo (jachguate) Sadly. is there any plan to support it on a later version? It's known which version? |
Commented by: Mason Wheeler (masonwheeler) What's the rationale for this? Most other serious RDBMSes have a way to define external aggregates. It's something that's very noticeably lacking from Firebird. |
Commented by: @asfernandes Probably in the next major version. |
Submitted by: Igor Lobov (ivl)
Is duplicated by CORE3162
Votes: 9
Create a way to create aggregate UDFs
The text was updated successfully, but these errors were encountered: