> x...@thebuild.com wrote:
>
> There is no first-class "identifier" type in PostgreSQL, so a function can't
> "return an identifier." It returns a string which might, when placed into a
> larger string and processed as SQL, be lexically correct as an identifier.
It takes huge discipline always
> adrian.kla...@aklaver.com wrote:
>
> The way I see is if it where an actual identifier then this:
>
> select * from quote_ident('$dog');
>
> quote_ident
> -
> "$dog"
>
> would be equal to this:
>
> select * from "$dog";
I think that the clue here is to go into philosophical over
> t...@sss.pgh.pa.us wrote:
>
>> david.g.johns...@gmail.com writes:
>>
>> So I can see an argument for the existing behavior. It doesn't seem worth
>> changing in any case. And I don't really see the documentation being
>> improved by covering this corner case in detail when the current behavio
> On Oct 5, 2022, at 17:16, Bryn Llewellyn wrote:
> B.t.w, the value of "quote_ident()" rests on the distinction between a name
> (what you provide with the function's actual argument) and an identifier
> (what it returns).
There is no first-class "identifier" type in PostgreSQL, so a functi
On 10/5/22 17:16, Bryn Llewellyn wrote:
The doc for "quote_ident()" says this:
«
https://www.postgresql.org/docs/14/functions-string.html
Returns the given string suitably quoted to be used as an identifier in an SQL
statement string. Quotes are added only if necessary (i.e., if the string
con
"David G. Johnston" writes:
> So I can see an argument for the existing behavior. It doesn't seem worth
> changing in any case. And I don't really see the documentation being
> improved by covering this corner case in detail when the current behavior
> is at least intuitive.
quote_ident is a go
On Wed, Oct 5, 2022 at 5:17 PM Bryn Llewellyn wrote:
> The doc for "quote_ident()" says this:
>
> «
> https://www.postgresql.org/docs/14/functions-string.html
> Returns the given string suitably quoted to be used as an identifier in an
> SQL statement string. Quotes are added only if necessary (i
The doc for "quote_ident()" says this:
«
https://www.postgresql.org/docs/14/functions-string.html
Returns the given string suitably quoted to be used as an identifier in an SQL
statement string. Quotes are added only if necessary (i.e., if the string
contains non-identifier characters or would b
út 4. 10. 2022 v 23:02 odesílatel Bruce Momjian napsal:
>
> Would people be interesting in subscribing to a Postgres calendar that
> includes dates for minor releases, final minor release dates for major
> versions, commit fests, and even Postgres events? For example, it could
> include informati
Laurenz Albe writes:
> On Wed, 2022-10-05 at 16:38 +0200, Dominique Devienne wrote:
>> For selects, I have [PQnTuples][2], but what to do on INSERT, UPDATE, DELETE?
>> Parse the result of PQcmdTuples myself??? If so, what's the 0 in the
>> INSERT below?
> Yes, you have to use PQcmdTuples(), and y
> On Oct 5, 2022, at 09:32, Kaushal Shriyan wrote:
>
> Hi,
>
> Is replication possible between PostgreSQL support Master database running
> 9.6.1 version which is a lower version to Standby/Slave running version
> 10.17?
Binary replication is not possible between different major versions.
Hi,
Is replication possible between PostgreSQL support Master database
running 9.6.1 version which is a lower version to Standby/Slave running
version 10.17?
I have a datacenter *DC1* which is a production environment and serves live
customer traffic hosting Master PostgreSQL database version *9.
On Wed, 2022-10-05 at 16:38 +0200, Dominique Devienne wrote:
> Hi,
>
> Is there a way to programmatically now how many rows an UPDATE did update?
> I've read about [PQcmdTuples][1], but surely I shouldn't have to parse
> that string, no?
> For selects, I have [PQnTuples][2], but what to do on INSE
Hi,
Is there a way to programmatically now how many rows an UPDATE did update?
I've read about [PQcmdTuples][1], but surely I shouldn't have to parse
that string, no?
For selects, I have [PQnTuples][2], but what to do on INSERT, UPDATE, DELETE?
Parse the result of PQcmdTuples myself??? If so, what
On 04.10.22 23:02, Bruce Momjian wrote:
Would people be interesting in subscribing to a Postgres calendar that
includes dates for minor releases, final minor release dates for major
versions, commit fests, and even Postgres events?
Events already exists:
https://calendar.google.com/calendar/ic
Do you need any additional information?
-Original Message-
From: Lahnov, Igor
Sent: Friday, September 30, 2022 10:18 AM
To: 'Michael Paquier'
Cc: Kyotaro Horiguchi ;
pgsql-general@lists.postgresql.org; Timonin, Alexey
; Dmitriyev, Andrey
Subject: RE: Streaming wal from primiry termina
16 matches
Mail list logo
