3 ms·
...and no mention at all of recursive CTEs. My favorite ridiculous use-case for them: https://wiki.postgresql.org/wiki/Mandelbrot_set https://wiki.postgresql.o
by rosser 12y ago
...and no mention at all of recursive CTEs.
My favorite ridiculous use-case for them: https://wiki.postgresql.org/wiki/Mandelbrot_set https://wiki.postgresql.org/wiki/Mandelbrot_set
(For reference, that ran in 252ms on my low-end Linode.)
- gtaylor 12y agoI didn't think Oracle SQL server has CTEs, but maybe that's changed. Postgres CTEs are amazing, though. Surprisingly efficient for our particular usage case (threaded discussions that don't ever get too deep).
- thebillkidy 12y agoOracle SQL Indeed has CTE's :) I mentioned those together with other special use cases in previous articles on my blog.
- dragonwriter 12y agoOracle has recursive CTEs since, I think, 11gR2, and non-recursive CTEs since 9.2.