@Test public void stripsNullsFromArraysWhenRequested() { Field<Integer[]> agg = PostgresSupport.arrayAggNoNulls(Table1.FIELD_ID1); String columnName = Table1.FIELD_ID1.toString(); assertThat(agg.toString()).isEqualTo("array_remove(array_agg(" + columnName + "), NULL)"); }
@Support({SQLDialect.POSTGRES}) public static <T> Field<T[]> arrayAggNoNulls(Field<T> field) { return DSL.field("array_remove(array_agg({0}), NULL)", field.getDataType().getArrayType(), field); }
PostgresSupport { @Support({SQLDialect.POSTGRES}) public static <T> Field<T[]> arrayAggNoNulls(Field<T> field) { return DSL.field("array_remove(array_agg({0}), NULL)", field.getDataType().getArrayType(), field); } }
PostgresSupport { @Support({SQLDialect.POSTGRES}) public static <T> Field<T[]> arrayAggNoNulls(Field<T> field) { return DSL.field("array_remove(array_agg({0}), NULL)", field.getDataType().getArrayType(), field); } private  PostgresSupport(); }
PostgresSupport { @Support({SQLDialect.POSTGRES}) public static <T> Field<T[]> arrayAggNoNulls(Field<T> field) { return DSL.field("array_remove(array_agg({0}), NULL)", field.getDataType().getArrayType(), field); } private  PostgresSupport(); @Support({SQLDialect.POSTGRES}) static Field<T[]> arrayAgg(Field<T> field); @Support({SQLDialect.POSTGRES}) static Field<T[]> arrayAggNoNulls(Field<T> field); @Support({SQLDialect.POSTGRES}) static Field<String> stringAgg(Field<String> field, String delimiter); }
PostgresSupport { @Support({SQLDialect.POSTGRES}) public static <T> Field<T[]> arrayAggNoNulls(Field<T> field) { return DSL.field("array_remove(array_agg({0}), NULL)", field.getDataType().getArrayType(), field); } private  PostgresSupport(); @Support({SQLDialect.POSTGRES}) static Field<T[]> arrayAgg(Field<T> field); @Support({SQLDialect.POSTGRES}) static Field<T[]> arrayAggNoNulls(Field<T> field); @Support({SQLDialect.POSTGRES}) static Field<String> stringAgg(Field<String> field, String delimiter);  }