Vanessa tornich wrote:
> Open C1;
> LOOP
> Fetch C1 into v_ano, v_uf, v_cont;
> Exit when not found;
> CASE upper(v_uf)
^^^^^^^^^^
A cláusula CASE só pode ser utilizada dentro do comando SELECT. Você vai
ter que utilizar o IF-ELSIF-ELSE [1].
[1]
http://www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-CONDITIONALS
--
Euler Taveira de Oliveira
http://www.timbira.com/
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
