Re: Inconsistent compilation error

> I'm unsure why you're considering
>'blah_history.original_id' not to be an argument here.

On Wed, Apr 18, 2018 at 9:50 PM, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
wrote:

> On 19 April 2018 at 13:28, Melvin Davidson <melvin6925(at)gmail(dot)com> wrote:
> > It is not fine. You have specifed TWO percent signs (%) which requires
> TWO
> > argumenrts,
> > but you have only provided ONE -> r.
>
> I'm confused about this statement.
>
> Did you perhaps overlook the fact that there are in fact two
> arguments? I'm unsure why you're considering
> 'blah_history.original_id' not to be an argument here.
>
>
> --
> David Rowley http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>

There are two possibilities here.
1`. The compiler might be expecting a variable and not accepting a text
literal.
Normally, literals are inside the first quotes. IE: raise notice '
blah_history.original_id' %', r;
OR
2. since this is in a loop, r might be NULL

--
*Melvin Davidson*
*Maj. Database & Exploration Specialist*
*Universe Exploration Command – UXC*
Employment by invitation only!