> At 02:07 PM 2/21/00 -0500, Bruce Momjian wrote:
>
> >
> >I am totally confused why "from bar bar" is different from "bar".
>
> In the rule created for the view, the from clause gets generated
> like this:
>
> "from foo (list of columns), ..."
>
> or - if an explicit range table name is given
>
> "from foo foo (list of columns), ..."
Got it:
test=> select * from pg_class pg_class (relname);
Wow, that is some strange syntax, and I didn't know we even allowed
that.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026