News for hackers. Stuff that matters.
Re:Following a Select Statement Through Postgres Internals by talaketu on Monday October 13, 2014 @09:07PM (#8451429)
Unless "name" is unique, there could be multiple matches. Asking for the "first" demands an ordering.

Perhaps (a) the user doesn't care what ordering is used, and/or (b) (such as in your example in the preceding post) hasn't specified an order (and apparently PK ordering is defaulted to PK - a model option?). It would be error-prone for ORM to take (b) as implying (a).

Re:Following a Select Statement Through Postgres Internals by pat_shaughnessy on Monday October 13, 2014 @09:15PM (#8451455)
Yes, good point. Rails has a lot of conventions like this - that "first" implies ordering by primary key (by default). I just imagine that most Rails developers don't think about sorting and its implications when they ask for the first record.