2009/12/16 Alipio Dantas <[email protected]>
>
> <corte>
>
> create or replace function sequencia_desembolso_pac_embasa ()
> Returns trigger as $$
> begin
>
> SELECT setval('pac.pac_desembolso_obra_deob_id_seq', max(deob_id)) FROM
> pac.pac_desembolso_obra;
>
> end;
> $$ language PLPGSQL;
>
> <corte>
>
>
Tente assim:
create or replace function sequencia_desembolso_pac_embasa ()
returns trigger as $$
begin
perform setval('pac.pac_desembolso_obra_deob_id_seq', (select max(deob_id)
from pac.pac_desembolso_obra));
return new;
end;
$$ language PLPGSQL;
Cordialmente,
--
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
