Re: [SQL] Error when selecting rows from a temporary table in ODBC

2001-03-21 Thread Tom Lane
Hiroshi Inoue <[EMAIL PROTECTED]> writes: > Ligia Pimentel wrote: >> conn=57295424, query='drop table tmp_cr; drop table tmp_db; select >> sum(valor) as totalCR, count(correlativo) as docsCR, caja into tmp_cr from >> transaccion as t, codigocaja as c where c.codigo = t. codigo and c.tipomov = >> '

Re: [SQL] Error when selecting rows from a temporary table in ODBC

2001-03-21 Thread Hiroshi Inoue
Ligia Pimentel wrote: > > When we execute this query in psql over linux, we don't get any errors > > select sum(valor) as totalCR, count(correlativo) as docsCR, caja into tmp_cr > from transaccion as t, codigocaja as c > where c.codigo = t. codigo > and c.tipomov = 'CR' > group by caja; > > sele

[SQL] Error when selecting rows from a temporary table in ODBC

2001-03-21 Thread Ligia Pimentel
When we execute this query in psql over linux, we don't get any errors select sum(valor) as totalCR, count(correlativo) as docsCR, caja into tmp_cr from transaccion as t, codigocaja as c where c.codigo = t. codigo and c.tipomov = 'CR' group by caja; select sum(valor) as totalDB, count(correlativ