News for hackers. Stuff that matters.

A comment on Recursive Postgres Queries. Parent comment

Re:Recursive Postgres Queries by masklinn on Monday June 24, 2013 @01:45PM (#5934481)
> The SQL itself is also non-portable

?

CTE is part of SQL:1999 and most RDBMS support it: http://en.wikipedia.org/wiki/Hierarchical_and_recursive_quer...

Or are you using some odd custom definition of the word "portable"?

[ Parent | on HN ]
Re:Recursive Postgres Queries by dragonwriter on Monday June 24, 2013 @01:55PM (#5934532)
CTEs are portable, but the sorting piece of the solution relies on PostgreSQL's arrays, which are not portable. Even with CTEs, I think doing sort-by-path in a portable way is going to be ugly (arrays make it very nice.)
[ Parent | on HN ]