Add support for CTE (Common Table Expressions / WITH-clause) #454

Closed
lukaseder opened this Issue Jul 22, 2012 · 3 comments

Comments

Projects
None yet
2 participants
@lukaseder
Owner

lukaseder commented Jul 22, 2012

This clause can also be used for recursive queries similar to Oracle's CONNECT BY clause:

http://msdn.microsoft.com/en-us/library/ms186243.aspx

At least these dialects support it:

  • DB2
  • Firebird
  • H2 (only the recursive variant)
  • Oracle
  • PostgreSQL
  • Teradata
  • SQL Server
  • Sybase

http://stackoverflow.com/questions/6401222/connect-by-or-hierarchical-queries-in-rdbms-other-than-oracle

@GuiSim

This comment has been minimized.

Show comment Hide comment
@GuiSim

GuiSim Apr 25, 2014

Really looking forward to this feature. Glad it was not forgotten after two years!

GuiSim commented Apr 25, 2014

Really looking forward to this feature. Glad it was not forgotten after two years!

@lukaseder

This comment has been minimized.

Show comment Hide comment
@lukaseder

lukaseder Apr 25, 2014

Owner

We never forget! And we always embrace contributions, you know? :-)

Owner

lukaseder commented Apr 25, 2014

We never forget! And we always embrace contributions, you know? :-)

@lukaseder

This comment has been minimized.

Show comment Hide comment
@lukaseder

lukaseder Jun 3, 2014

Owner

This feature can be considered implemented :-) (finally)

Owner

lukaseder commented Jun 3, 2014

This feature can be considered implemented :-) (finally)

@lukaseder lukaseder closed this Jun 3, 2014

@lukaseder lukaseder added the R: fixed label Jun 3, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment