Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
adwf
on Jan 8, 2014
|
parent
|
context
|
favorite
| on:
The best Postgres feature you're not using – CTEs ...
The advantage of CTEs is they have the explicit "WITH RECURSIVE" option. Whereas an aliased SELECT statement can't refer to itself as far as I know.
twic
on Jan 8, 2014
|
next
[–]
Recursive CTEs are super amazing. One of the great underused features of SQL. Give me tall PostgreSQL and a WITH RECURSIVE to steer by, and i will happily take on any graph database.
Not promising i'll win, mind.
socialist_coder
on Jan 8, 2014
|
prev
[–]
Ahhh, just read about that. The equivalent of the Oracle "start with, connect by" clause (
http://docs.oracle.com/cd/B19306_01/server.102/b14200/querie...
). Good to know.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
