Hello
I played with CTE and I have to say, it's great feature - great work.
One questions - can I enforce materialisation of query?
It would be usefull for some analytical queries like:
with tmp as (select a, sum(b) as b from test) select * from tmp union
all select 'all', sum(b) from tmp;
reg
On Sun, Jul 27, 2008 at 10:37:34AM +0100, Simon Riggs wrote:
>
> On Sat, 2008-07-26 at 11:03 -0700, Joshua D. Drake wrote:
>
> > 2. We have no concurrency which means, anyone with any database over 50G
> > has unacceptable restore times.
>
> Agreed.
>
> Also the core reason for wanting -w
>
>
> At David's request I've been looking through this patch.
>
> Regarding documentation: if it would help, I can write some; I have
> already made a start on writing down what is going on internally in
> order to understand it myself.
Thanks. There was some docs written in Japanese by Yoshiyuki. R
Stephen R. van den Berg wrote:
>My Pike drivers now support multiple simultaneous portals and
>automatic streaming by presending overlapping Execute statements with
>a dynamically adapted fetchlimit calculated per select as the query
>progresses.
They also support COPY now.
The driver beats libpq
