pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedmistype
4+ messages / 3 participants
[nested] [flat]
* mistype
@ 2017-08-25 19:19 splarv@ya.ru
2017-08-28 22:25 ` Re: mistype David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: splarv@ya.ru @ 2017-08-25 19:19 UTC (permalink / raw)
To: pgsql-docs
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/sql-expressions.html
Description:
cite "The restriction about appearing only in the result list or HAVING
clause applies with respect to the query level that the aggregate belongs
to."
May be "the restriction above"?
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: mistype
2017-08-25 19:19 mistype splarv@ya.ru
@ 2017-08-28 22:25 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: David G. Johnston @ 2017-08-28 22:25 UTC (permalink / raw)
To: splarv@ya.ru; +Cc: pgsql-docs
On Fri, Aug 25, 2017 at 12:19 PM, <splarv@ya.ru> wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/sql-expressions.html
> Description:
>
> cite "The restriction about appearing only in the result list or
> HAVING
> clause applies with respect to the query level that the aggregate belongs
> to."
>
> May be "the restriction above"?
>
Or, "The restriction that variables must appear only in the result list or
HAVING clause applies to the query level to which the aggregate expression
belongs." (I would consider emphasizing the word belongs).
Really, just adding the word variables - "The restriction about variables
appearing only" - would make it technically correct.
Your proposal of only changing "about" to "above" makes it grammatically
wrong and fails to fix the underlying problem. "about" it is right word
but the sentence fails to provide "what", what must only appear in the
result list or having clause?
A meaningful example might help too - I'm having trouble imaging when one
would choose to write a subquery whose effect would end up being treated as
part of the main query.
David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Mistype
@ 2017-08-27 09:30 splarv@ya.ru
2017-09-02 02:04 ` Re: Mistype Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 1 reply; 4+ messages in thread
From: splarv@ya.ru @ 2017-08-27 09:30 UTC (permalink / raw)
To: pgsql-docs
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/sql-createpolicy.html
Description:
"Note that INSERT with ON CONFLICT DO UPDATE checks INSERT policies' WITH
CHECK expressions only for rows appended to the relation by the INSERT
path."
May be "by the INSERT part"?
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Mistype
2017-08-27 09:30 Mistype splarv@ya.ru
@ 2017-09-02 02:04 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 0 replies; 4+ messages in thread
From: Peter Eisentraut @ 2017-09-02 02:04 UTC (permalink / raw)
To: splarv@ya.ru; pgsql-docs
On 8/27/17 05:30, splarv@ya.ru wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/sql-createpolicy.html
> Description:
>
> "Note that INSERT with ON CONFLICT DO UPDATE checks INSERT policies' WITH
> CHECK expressions only for rows appended to the relation by the INSERT
> path."
>
> May be "by the INSERT part"?
No this is correct.
The ON CONFLICT documentation frequently speaks of an "UPDATE path" and
an "INSERT path" that the command may end up taking.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2017-09-02 02:04 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-08-25 19:19 mistype splarv@ya.ru
2017-08-28 22:25 ` David G. Johnston <david.g.johnston@gmail.com>
2017-08-27 09:30 Mistype splarv@ya.ru
2017-09-02 02:04 ` Re: Mistype Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox