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
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