Re: Inconsistent compilation error

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, raf(at)raf(dot)org, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Inconsistent compilation error
Date: 2018-04-19 02:21:58
Message-ID: CAKFQuwa-ZwPKPAuKrEUQsgJbywYjRqsQXTBKVq_i3Fe-iDDibw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 18, 2018 at 7:04 PM, Melvin Davidson <melvin6925(at)gmail(dot)com>
wrote:

>
> Normally, literals are inside the first quotes. IE: raise notice '
> blah_history.original_id' %', r;
>

​But a compiler doesn't care about human concepts like "normally" - it just
cares about "syntactically correct" and as David and Tom observe the
original post as visually observed is correct. Which leads one to think
that reality and the original post somehow don't match, or as Tom said what
the server sees and what is sent end up being different (client encoding
issues or some such).

And pretty sure "r" being NULL just puts an empty string where the % is.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-04-19 03:16:20 Re: Inconsistent compilation error
Previous Message Tom Lane 2018-04-19 02:06:20 Re: Inconsistent compilation error