YugaByte DB PostgreSQL Compatibility

This table documents the compatibility of YugaByte DB against a comprehensive list of PostgreSQL commands and syntax. In the first column you can find a links with the queries you'll need to test the compatibility yourself.

Functional Category	Feature	YugaByte 1.3	Notes
Fundamentals	SELECT data from one column	✔️
	SELECT data from multiple columns	✔️
	SELECT data from all columns	✔️
	SELECT with an expression	✔️
	SELECT with an expression, but without a FROM clause	✔️
	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