On Mon, 07 Feb 2005 13:51:46 -0800, Joshua D. Drake
<jd@xxxxxxxxxxxxxxxxx> wrote:
> Well your first email didn't explain that you were doing the below :)
In the first email I was not doing the insert. I was executing a psql script:
$ psql -e -f groupdup.psql ks2
This was the groupdup.psql script:
\pset format unaligned
\pset fieldsep '\t'
\pset tuples_only
\o '/KakaoStats/bak/groupdup.txt'
select
data,
usuario,
sum(pontos),
sum(wus)
from usuarios
group by data, usuario
;
\o
\pset tuples_only
\pset format aligned
I was planning to insert the file with copy from.
> Is this the entire function?
Yes, it is the entire function.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
