From: | raf <raf(at)raf(dot)org> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Inconsistent compilation error |
Date: | 2018-04-25 11:54:01 |
Message-ID: | 20180425115401.haap5gwtgww5iw5g@raf.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
David G. Johnston wrote:
> 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.
passing a null value to raise notice outputs it as the string "NULL".
From | Date | Subject | |
---|---|---|---|
Next Message | raf | 2018-04-25 11:58:20 | Re: Inconsistent compilation error |
Previous Message | raf | 2018-04-25 11:52:28 | Re: Inconsistent compilation error |