Details
Major
Description
Suppose you've got a posts table with a uid foreign key into the users table.
Wouldn't it be nice if you could say
select *, uid->name, uid->avatar from posts
instead of
select p.*, u.name, u.avatar from posts p left join users u using (uid) ?
It'd save typing a lot of joins and significantly simplifies writing and reading queries.
Note the syntax isn't the important part, I simply used the C way of dereferencing a pointer.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Since t1.a is not a foreign key it can't be dereferenced with this proposed feature.
Sorry, bug on select, t2.b is a foreign key.
Didn't know that was legal. So, only allow dereferencing for single / deterministic references.
So could you reopen this?
Sorry, I really do not see enough reason to implement what you are suggesting.
I understant your idea but what you suggest is not part of SQL-standard. In my opinion we should not extend SQL syntax on this case.