CTE bug?
| От | David Fetter |
|---|---|
| Тема | CTE bug? |
| Дата | |
| Msg-id | 20090908201503.GA3321@fetter.org обсуждение исходный текст |
| Ответы |
Re: CTE bug?
|
| Список | pgsql-hackers |
Folks, I tried the following and it broke: WITH RECURSIVE t(j) AS ( WITH RECURSIVE s(i) AS ( VALUES (1) UNION ALL SELECT i+1 FROM s WHERE i < 10 )SELECT i AS j FROM s UNION ALL SELECT j+1 FROM t WHERE j < 10 ) SELECT * FROM t; ERROR: relation "s" does not exist LINE 6: ) SELECT i AS j FROM s ^ Shouldn't this work? Cheers, David. -- David Fetter <david@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
В списке pgsql-hackers по дате отправления: