Programming the SQL Way with Common Table Expressions


Comments are closed.

I appreciated the first part of your talk. It gave me what I needed. Things got progressively more postgres-y from there. I do have a good enough understanding now to start working with cte in tsql (with minor syntax changes). You certainly had the feel of a university professor giving a lecture (it took me back to my CS days).

The slides are here:

Seth is right that I used more Postgres functions in the second half of the talk.

It was one of my top 3 talks at Confoo. Very interesting. Easy to understand. Unhappily for me, doesn't work (yet) for MySQL.

PS : Bruce I asked you if MySQL planned to integrate the CTE. Actually, I've been told it is but no date yet.

Very interesting, but not sure I will use it. Good talk.