Re: Vectors in Pl/PgSQL - Mailing list pgsql-general

From Tom Lane
Subject Re: Vectors in Pl/PgSQL
Date
Msg-id 28446.1040611160@sss.pgh.pa.us
Whole thread Raw
In response to Vectors in Pl/PgSQL  (Oleg Lebedev <oleg.lebedev@waterford.org>)
List pgsql-general
Oleg Lebedev <oleg.lebedev@waterford.org> writes:
>     EXIT WHEN rec.indkey[i] IS NULL;

You'll need to drop out of the loop on either zero or null, I think.

>     RAISE NOTICE ''uind col: %'', rec.indkey[i];

IIRC, the RAISE statement is very very restrictive about what it will
take.  The syntax error is probably coming from here.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PerformPortalClose warning in 7.3
Next
From: "Billy G. Allie"
Date:
Subject: Re: {GENERAL]