Re: Data Type Size Calculation

https://www.depesz.com/2022/02/13/how-much-disk-space-you-can-save-by-using-int4-int-instead-of-int8-bigint/ Hope this link is useful. create table testb as select 'true'::bool as b from generate_series(1,100) i;SELECT 100 $ \dt+ testb List of relation

Re: Question about role attributes docs

On Tue, Feb 15, 2022 at 1:32 PM Shinya Kato wrote: > On 2022-01-12 02:07, Laurenz Albe wrote: > > On Tue, 2022-01-11 at 16:40 +0900, Shinya Kato wrote: > >> I have a question about the documentation on ROLE. > >> > >> According to [1], INHERIT and BYPASSRLS can be specified when > >> executing >

Re: Data Type Size Calculation

For now, yes... I'm suggesting that the documentation be completed by adding a few sentences few extra sentences. Troy. # On Mon, Feb 14, 2022, 12:51 Bruce Momjian wrote: > On Fri, Feb 11, 2022 at 08:12:08PM +, PG Doc comments form wrote: > > The following documentation comment has been log

Does the POSITION() function takes into account the COLLATION... or not ?!?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-string.html Description: The doc doesn't say anything about the impact of the COLLATION on the results of any of the string functions, so I tried some interesting tests with POSI

Re: Doc says nothing about wether CREATE OR REPLACE VIEW can change the COLLATION of an existing field

On Tue, Feb 15, 2022 at 8:04 AM PG Doc comments form wrote: > For this reason, I'm also filling a bug report, since postgresql's reaction > was not adapted to my request (neither an appropriate error message nor > successful execution of my SQL statement). > The bug report is valid and sufficien

Re: tutorial problem solution requires that problem is already fixed

On Tue, Feb 15, 2022 at 8:04 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/role-attributes.html > Description: > > I am reporting my roadblock, so it can be better documented in the future. > > I a

Doc says nothing about wether CREATE OR REPLACE VIEW can change the COLLATION of an existing field

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createview.html Description: What the doc says about CREATE OR REPLACE VIEW : "The new query must generate the same columns that were generated by the existing view query (that is, th

tutorial problem solution requires that problem is already fixed

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/role-attributes.html Description: I am reporting my roadblock, so it can be better documented in the future. I am following this tutorial: https://www.postgresql.org/docs/14/tutorial-crea