Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
Date
Msg-id CAKFQuwZ-5VyPiFLPVYZcH-37g513OuJvj6kHkw_skfKyW1yFQA@mail.gmail.com
Whole thread Raw
In response to Re: How to ensure column names are double quoted while using execute format when building a stored procedure?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: How to ensure column names are double quoted while using execute format when building a stored procedure?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
On Thu, Dec 16, 2021 at 3:04 PM Adrian Klaver <adrian.klaver@aklaver.com> 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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
Next
From: Adrian Klaver
Date:
Subject: Re: How to ensure column names are double quoted while using execute format when building a stored procedure?