Today I Learned

hashrocket A Hashrocket project

Ignoring the limit clause in SQL

Passing null or all to the limit clause effectively ignores the limit clause.

-- both statements return all user emails
select email from users limit null;
select email from users limit all;
Looking for help? Hashrocket developers believe that data quality is as important as code quality. We enjoy all the challenges of relational databases, from finding the fastest index, to structuring data to fit the needs of an application. We're eager to share our experiences; check out PG Casts, our series of free PostgreSQL screencasts.