> 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.row...@2ndquadrant.com> wrote: > On 19 April 2018 at 13:28, Melvin Davidson <melvin6...@gmail.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!