Re: timestamp with time zone ~> GMT

2025-02-03 Thread Tom Lane
Zulu GMT+10 GMT+3 GMT+7 GMT-1 GMT-13 GMT-4 GMT-8 UCT Maybe we could move the info to the Glossary, but that seems like a separate matter from what's under discussion here. regards, tom lane

Re: timestamp with time zone ~> GMT

2025-02-07 Thread Tom Lane
Robert Treat writes: > On Thu, Feb 6, 2025 at 5:33 PM Tom Lane wrote: >> Here's a combined proposal that also adds glossary entries. > +1 OK, pushed. regards, tom lane

Re: timestamp with time zone ~> GMT

2025-02-06 Thread Tom Lane
Robert Treat writes: > On Mon, Feb 3, 2025 at 12:23 PM Tom Lane wrote: >> Hmm, I kind of like the up-front statement that timestamptz stores >> UTC. How about this simpler change? > I thought the re-order made sense since the preceding paragraph talks > exclusively ab

Re: creating a database

2025-02-02 Thread Tom Lane
suitable alterations (or added to the end of Architectural Fundamentals, perhaps). Both of these pages are oriented towards "access Postgres from a terminal command line", which I concede is probably a minority thing anymore. regards, tom lane

Re: Size limit for NOTIFY payload

2024-12-18 Thread Tom Lane
atabase boundaries ... but they don't today.) regards, tom lane

Re: Typo on tutorial window page

2025-01-21 Thread Tom Lane
parameter, because its behavior is entirely determined by the OVER clause. regards, tom lane

Re: Request for Formal Syntax of WHERE Clause Conditions

2025-01-21 Thread Tom Lane
web/?p=postgresql.git;a=blob;f=src/backend/parser/gram.y;h=d7f9c00c4099bd86c39ce79c997123a2a0ca6782;hb=HEAD starting more or less from the a_expr production. Keep in mind that this is a moving target, as we frequently add new syntax features. regards, tom lane

Re: Typo on tutorial window page

2025-01-21 Thread Tom Lane
2 sales | 1 | 5000 |1 sales | 4 | 4800 |2 sales | 3 | 4800 |2 (10 rows) The ranks are separate within each partition (depname), and within a partition rows having the same salary get the same rank. regards, tom lane

Re: substring synopsis section, third argument is optional doc didn't show that

2025-01-21 Thread Tom Lane
section (9.7.3). For example, regression=# select substring('foobar', 'o.b'); substring --- oob (1 row) regression=# select substring('foobar', 'o.b', ''); substring --- (1 row) because '.' is a metacharacter in POSIX but not SQL regexps. regards, tom lane

Re: https://www.postgresql.org/docs/current/kernel-resources.html

2025-01-23 Thread Tom Lane
e in supporting two different implementations. regards, tom lane

Re: timestamp with time zone ~> GMT

2025-01-27 Thread Tom Lane
politicians keep changing the DST laws, so the meaning could change. In certain cases like appointment calendars, tracking local law is just what you want ... but in cases like flight schedules, probably not. regards, tom lane

Re: WHEN SQLSTATE '00000' THEN equals to WHEN OTHERS THEN

2025-03-19 Thread Tom Lane
se internally to represent OTHERS. We could use -1, which AFAICS cannot be generated by MAKE_SQLSTATE. regards, tom lane

Re: SEQUENCE NAME syntax not documented for ALTER TABLE

2025-03-23 Thread Tom Lane
ntity column. See CREATE TABLE for details. Where do you see a pointer to CREATE SEQUENCE on that page? regards, tom lane

<    3   4   5   6   7   8