I have to show for each register the number of the row.So a thought the
following code:
create temp sequence rownum;
select nextval('rownum') as rownum
, trim(lower(mneu_for)) as mneu_for
, trim(nome_for) as nome_for
from sbd95.fornec;
When I execute the code it´s run ok.So, I go public schema to see if it´s there
and it´s not.Then I tried to execute again,
and the DataBase ruturned me this message error: "ERROR: relation "rownum"
already exists
SQL state: 42P07"
What´s happen?
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
