Re: recursive view syntax
Peter Eisentraut <peter_e@gmx.net>
From: Peter Eisentraut <peter_e@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Date: 2012-11-15T03:44:18Z
Lists: pgsql-hackers
On Tue, 2012-11-13 at 23:44 -0500, Tom Lane wrote: > Peter Eisentraut <peter_e@gmx.net> writes: > > I noticed we don't implement the recursive view syntax, even though it's > > part of the standard SQL feature set for recursive queries. Here is a > > patch to add that. > > Can't you simplify that by using "SELECT * FROM name"? You mean in the expansion? Maybe, but SELECT * is perhaps something best avoided because of unclear side effects.