Search Postgresql Archives

Re: How to ensure column names are double quoted while using execute format when building a stored procedure?

Subject: Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Thu, 16 Dec 2021 15:11:52 -0700
Cc: Shaozhong SHI <shishaozhong@xxxxxxxxx>, pgsql-general <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <e7c25fae-fc9b-1964-3294-3ae478f2e286@aklaver.com>
References: <CA+i5JwYMbWKoJcP-o4HOY-G1YegxGs2FE0bWDanEF5g2WRj5yQ@mail.gmail.com> <CAKFQuwbGYaCzAhyqu2FMB6xVYMNBjWEGRiGz873AnzMysF9a5w@mail.gmail.com> <CA+i5JwbDUx6kWe5bkWJkHJjEVOEuojWJSxLfnxDQ5Cj_+v7XnQ@mail.gmail.com> <e7c25fae-fc9b-1964-3294-3ae478f2e286@aklaver.com>

On Thu, Dec 16, 2021 at 3:04 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:

This:

'count of nulls in "UNIQUE_REFERENCE_NUMBER"'

is just plain incorrect syntax.

<single quote>count of nulls in <double quote>UNIQUE_REFRENCE_NUMBER<double quote><single quote>

That is not invalid syntax. It is just literal single quoted text - the double quotes are simply characters in the string.

David J.

Follow-Ups:
- Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
  - From: Adrian Klaver

References:
- How to ensure column names are double quoted while using execute format when building a stored procedure?
  - From: Shaozhong SHI
- Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
  - From: David G. Johnston
- Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
  - From: Shaozhong SHI
- Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
  - From: Adrian Klaver