Re: Case Insensitive Comparison with Postgres 12

Hello, use correct locale identifier, in your case it should be: create collation "case_insensitive" (provider=icu, locale="en-US-u-ks-level2", deterministic = false); See http://www.unicode.org/reports/tr35/tr35-collation.html#Setting_Options for available options. -- Pavel Dne 09.10.2019

Re: Creating a function

Hi, something like this? create or replace FUNCTION "IncentiveBin"(in Gwac double precision, in MtgRaate double precision, in BinSize double precision) RETURNS double precision LANGUAGE sql VOLATILE