Re: Question about exposing additional built-in operators

2020-07-08 Thread Julian Hyde
Add something like this to SqlLibraryOperators: @LibraryOperator(libraries = {POSTGRESQL}) public static final SqlFunction LENGTH = ...; and create your JDBC connection with 'fun=postgresql'. LENGTH is not part of the SQL standard, so it should not be in SqlStdOperatorTable. Nor should you

Question about exposing additional built-in operators

2020-07-08 Thread James Anderson
Hi, Is there a mechanism to add/register additional standard operators to be used by Calcite when defining a model for a JDBC connection? I had hoped that annotating new functions with LibraryOperator(libraries={STANDARD}) would work but it doesn't seem to be the case, or I'm doing it