Thank you
With UNION ALL the SQL work correct for my case...
Dario.
Tom Lane escreveu:
Dario Basso Cardoso <[EMAIL PROTECTED]> writes:
I receive two (2) rows if i union with other table i receive one (1) row!!!
You do know that UNION is defined to eliminate duplicate output rows?
(
Dario Basso Cardoso <[EMAIL PROTECTED]> writes:
> I receive two (2) rows if i union with other table i receive one (1) row!!!
You do know that UNION is defined to eliminate duplicate output rows?
(UNION ALL doesn't eliminate duplicates, and might be what you want.)
If that's not what you're seein
Hi,
I have PostgreSQL 8.0.3 for Windows XP and i have in attach the database
with problem.
The problem occour with this SQL
select proextra.data as data, 0 as codigo, proextra.motivo as nome, 'X'
as tipo, proextra.qtd, 0 as valor_u, 0 as cod_v from proextra where
proextra.data>=to_date('28/
