On 24.04.25 17:13, Robert Treat wrote:
On Fri, Apr 11, 2025 at 8:45 AM Euler Taveira wrote:
On Fri, Apr 11, 2025, at 5:32 AM, Yaroslav Saburov wrote:
On the tutorial-agg page in the code example
SELECT city FROM weather WHERE temp_lo = max(temp_lo); WRONG
you need to add a comment before WRON
On Fri, Apr 11, 2025 at 8:45 AM Euler Taveira wrote:
> On Fri, Apr 11, 2025, at 5:32 AM, Yaroslav Saburov wrote:
> On the tutorial-agg page in the code example
>
> SELECT city FROM weather WHERE temp_lo = max(temp_lo); WRONG
>
> you need to add a comment before WRONG
>
> If you consider that that
On Fri, Apr 11, 2025, at 5:32 AM, Yaroslav Saburov wrote:
>
> Thank you all.
>
>
>
> In order not to open a new thread, (small clarification)
>
Don't be afraid to open a new thread. Indeed, a new topic (even if it is
minimal) deserves a new thread.
> On the tutorial-agg page in the code exam
te; or perhaps I did realize that but figured
> it was still applicable to versions in the field.)
>
> I concur with David that we should just drop the para. It's merely
> confusing now. If you have a generated constraint name, it won't
> require double-quoting unless your table or column name does, and
> if they do you are doubtless already quite familiar with how
> quoting works.
>
>regards, tom lane
s still applicable to versions in the field.)
I concur with David that we should just drop the para. It's merely
confusing now. If you have a generated constraint name, it won't
require double-quoting unless your table or column name does, and
if they do you are doubtless already quite familiar with how
quoting works.
regards, tom lane
url:
https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-
REMOVING-A-CONSTRAINT <https://www.postgresql.org/docs/current/ddl-
alter.html#DDL-ALTER-REMOVING-A-CONSTRAINT>
(If you are dealing with a generated constraint name like $2, don't
forget
ged on the website:
>>
>> Page: https://www.postgresql.org/docs/17/ddl-alter.html
>> Description:
>>
>> url:
>> https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-REMOVING-A-CONSTRAINT
>>
>> (If you are dealing with a generated constraint na
gt; DDL-ALTER-REMOVING-A-CONSTRAINT
>
> (If you are dealing with a generated constraint name like $2, don't forget
> that you'll need to double-quote it to make it a valid identifier.)
>
> If I have a constraint with the name $2, are there other constraints with
> names $1, $3
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/ddl-alter.html
Description:
url:
https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-REMOVING-A-CONSTRAINT
(If you are dealing with a generated constraint name like $2
