[SQL] Execution plan Question

2003-03-10 Thread Objectz
have included both quiries with their excution plan. Regards, --ObjectZ Maker ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] Execution plan Question

2003-03-11 Thread ObjectZ
.3.01 rows=1 width=572) (actual time=0.02..0.02 rows=1 loops=10104) Total runtime: 438.96 msec EXPLAIN i need to know what happened in here On Tue, 2003-03-11 at 07:09, Objectz wrote: > Oops .. Here they are > >

[SQL] String aggregate function

2003-03-17 Thread Objectz
Hi all, I want to make an aggregate function that concatenates strings from a certain column into one cell in a group by clause. For example I have the following table : TypeText = 1 text1 2 text2 1 text3 3