Re: Backend-internal SPI operations

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(at)Yahoo(dot)com #