[Pgsql-ayuda] funciones...nuevamente

[Alvaro Herrera]

On Wed, Nov 12, 2003 at 01:46:16AM +0000, GUSTAVO MARTIN OCAMPO wrote:

> create or replace function extrae_year() returns trigger as '
> declare
> 	var_row RECORD;
> 	var_year year%ROWTYPE;
> begin
> 	for var_row in select distinct extract (year from 
> 	new.fecha_vencimiento) as fecha loop
> 
> 	    EXECUTE ''INSERT INTO ''
>                    || quote_ident(var_year.year) || '' ''
>                    || quote_literal(var_row.fecha);
> 	end loop;
> 	return null;
> end;'

Huh ... no entendí absolutamente nada.  ¿Qué quieres lograr?

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Sallah, I said NO camels! That's FIVE camels; can't you count?"
(Indiana Jones)