Re: Vectors in Pl/PgSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vectors in Pl/PgSQL
Date: 2002-12-23 02:39:20
Message-ID: 28446.1040611160@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Billy G. Allie 2002-12-23 06:00:28 Re: {GENERAL]
Previous Message Tom Lane 2002-12-23 02:36:27 Re: PerformPortalClose warning in 7.3