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 Adrian Klaver
Subject Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
Date
Msg-id 3d76aa2d-0e1e-8cff-49de-93be10a2a5ea@aklaver.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?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
On 12/16/21 14:11, David G. Johnston wrote:
> On Thu, Dec 16, 2021 at 3:04 PM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto: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.

Alright I took it to be what followed:

count("""UNIQUE_REFERENCE_NUMBER""").

Now I see it is a tag for the count.

> 
> David J.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
Next
From: Mladen Gogala
Date:
Subject: Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL