Hacker News new | ask | show | jobs
by JoelJacobson 1905 days ago
Hi Steve,

Many thanks for making PostgREST, I'm using it for all my projects!

I'm trying to understand the problem you see with self joins. Why would it be a problem? At the end of my comment, I gave an example with a users table, for such a table, an expression such as "FROM users JOIN users->parent" would join-in users two times, but two different rows of users, since "users->parent" would follow the foreign key "parent".