TODO-list

From: Dennis Björklund <db(at)zigo(dot)dhs(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: TODO-list
Date: 2003-04-21 05:17:29
Message-ID: Pine.LNX.4.44.0304210701150.2238-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Items that have names after them in the TODO-list, do these names indicate
that the persons are working on it now?

The item i'm extra curious about is

* Add SQL99 WITH clause to SELECT (Tom, Fernando)

There is also an item for handling recursive such clauses.

The simple non recursive case can be implemented in a straight forward
(but stupid) way, where one "just" substitute in for the variables. It
won't give any sharing effects that one can get by declaring a variable
once and use it several times. It will however make it much easier to
write readable SQL expressions. The sharing can be seen as just an
optimization anyway.

Also, it's not at all clear to me how to decide when one want to calculate
the subexpression first and use in the other places and when to duplicate
the expression to let the optimizer work with it. I however just want it
in order to make my SQL-code simpler and more expressive.

Maybe I should also point out that I have not implemented this so I can't
be sure that it really is just as simple as just substituting. It looks
like it after a quick look, that's all!

--
/Dennis

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-04-21 06:25:46 Re: TODO-list
Previous Message Lamar Owen 2003-04-21 02:00:16 Re: Upgrade to RedHat 9.0 broke PostgreSQL