i need a help for psql

[roger5089]

dear every one
if some one know this question please make help for me. my temp query is like it

startime | caller

12/12/02 roger
12/12/02 roger
12/12/02 roger
12/12/02 roger
12/12/02 roger
12/12/02 chuang
12/12/02 chuang
11/12/02 chen

and
how can i get result some thing like this

startime | total | oldcaller | newcaller
12/12/02 6 2 4
11/12/02 1 0 1

// if some one has strang psql exprience for subquery please help me up

roger

[Tbull]

Your post looks similar to the difficulty that I was experiencing. I think you are using Oracle, so the solution will probably be different, but take a look at the post:

--- MySQL Crosstab query? ---

and the suggestion which nnichols offered to me.

Hope it helps.

Tbull