YugaByte DB PostgreSQL Compatibility

Functional Category	Feature	YugaByte 1.3	CockroachDB 19.1.3	Queries	Notes
Basic	SELECT data from one column	Supported	Supported	SELECT
	SELECT data from multiple columns	Supported	Supported	SELECT
	SELECT data from all columns	Supported	Supported	SELECT
	SELECT with an expression	Supported	Supported	SELECT
	SELECT with an expression, but without a FROM clause	Supported	Supported	SELECT
	SELECT with a column alias
	SELECT with a table alias
	SELECT with an ascending ORDER BY
	SELECT with an descending ORDER BY
	SELECT with a ascending and descending ORDER BYs
	SELECT with DISTINCT on one column
	SELECT with DISTINCT including multiple columns
	SELECT with DISTINCT ON expression
	WHERE clause with an equal = operator
	WHERE clause with an AND operator
	WHERE clause with an OR operator
	WHERE clause with an IN operator
	WHERE clause with a LIKE operator
	WHERE clause with a BETWEEN operator
	WHERE clause with a not equal <> operator
	SELECT with a LIMIT clause
	SELECT with LIMIT and OFFSET clauses
	SELECT with LIMIT and ORDER BY clauses
	SELECT with FETCH and ORDER BY clauses
	SELECT with FETCH, OFFSET and ORDER BY clauses
	SELECT with an IN clause
	SELECT with a NOT IN clause
	SELECT with an IN clause in a subquery using CAST
	SELECT with BETWEEN
	SELECT with NOT BETWEEN
	SELECT with a LIKE operator
	SELECT with a LIKE operator using % and _
	SELECT with a NOT LIKE operator
	SELECT with an ILIKE operator
	SELECT with a IS NULL operator
	SELECT with a IS NOT NULL operator
	SELECT with an INNER JOIN
	SELECT with a LEFT OUTER JOIN
	SELECT with a LEFT OUTER JOIN with rows only from left table
	SELECT with RIGHT OUTER JOIN
	SELECT with FULL RIGHT OUTER JOIN
	SELECT with FULL OUTER JOIN
	SELECT with FULL OUTER JOIN with only unque rows in both tables