>
> Your example is not possible with any PL in PostgreSQL versions prior to
7.3
> (currently in beta testing). However, in 7.3, using PL/pgSQL it looks like
this:
by the way, when does it will be done???
>
> CREATE OR REPLACE FUNCTION my_proc(TIMESTAMP)
> RETURNS SETOF payments
> AS '
> DECLARE
> rec RECORD;
> BEGIN
> FOR rec IN SELECT * FROM payments
> WHERE r_date_payment BETWEEN $1 AND CURRENT_TIMESTAMP LOOP
> /*here I can do any check for each row of SELECT above!! */
would I be able to change the value of field? like:
IF r_value < 0 THEN
r_value = r_value*-1;
> RETURN NEXT rec; /* Each RETURN NEXT command returns a row */
> END LOOP;
> RETURN;
> END;
> ' LANGUAGE 'plpgsql';
>
> See:
>
http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.htm
l
> and
> http://developer.postgresql.org/docs/postgres/xfunc-tablefunctions.html
>
> HTH,
>
> Joe
>
>