Peter Eisentraut wrote:
> Jan Wieck writes:
>
> > Hmmm, don't know what you mean with that.
>
> If I define a view
>
> CREATE my_view AS SELECT a, b, c FROM my_table;
>
> and then do
>
> SELECT * FROM my_view;
>
> then it becomes
>
> SELECT * FROM (SELECT a, b, c FROM my_table);
>
> which would presumably be possible with the new query-tree.
Hmm - too simple - real life is harder. So to what do you expand the query
SELECT a, c, d FROM my_view, other_table WHERE my_view.a = other_table.a AND other_table.x =
'foo';
And then have a little more complex "my_view", maybe a join with it's own WHERE clause.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #