SQL Server
SQL / PostgreSQL How to Compare Arrays in PostgreSQL - PopSQL Basics: Data types: - INT : whole number - VARCHAR(number_characters) - DATE : yyy-mm-dd - BLOB: binary large object to store large data - TIMESTAMP: yyyy-mm-dd hh:mm-ss Compare Arrays 1. Equality operators (=, < >) do an exact element-by-element comparison select array[1, 2, 3] = array[1, 2, 4] as compare1, -- array are equal array[1, 2, 3] < > = array[1, 2, 4] as compare2; --array are not equal - Compare1 is false. - Comapre2 is True. 2. Ordering operators (>, <, >=, <=) also compare each element in an array in order. Result are based on the first different pair of element , not the s