Re: SELECT INTO - Mailing list pgsql-general

"Roberto de Amorim" <roberto@smartbit.inf.br> writes:
>             SELECT INTO V_PAYMENT "DATE_PAYMENT",
>                                       V_VALUE "VALUE"
>             FROM  "PAYMENTS"
>             WHERE
>               "ID" = NEW.ID;

That's not the right syntax.  Try

            SELECT INTO V_PAYMENT, V_VALUE  "DATE_PAYMENT", "VALUE"
            FROM  ... etc ...

            regards, tom lane