| Since the string literals are treated as bind params, database considers them as different. eg : PostgreSQL select count , to_char( .requested_delivery_date_time at time zone 'Asia/Kolkata', 'DD' ) from table_name group by to_char( .requested_delivery_date_time at time zone 'Asia/Kolkata', 'DD' ) Here I have two literals only, but during execution it will be 4 parameters, which will throw error complaining select and groupBy are different. |