Re: substring start position behavior

2024-03-26 Thread Bruce Momjian
On Tue, Mar 26, 2024 at 11:07:07AM -0400, Bruce Momjian wrote: > On Wed, Mar 6, 2024 at 12:42:09AM -0500, Tom Lane wrote: > > I'm kind of inclined to not document this weirdness. I especially > > don't think it's worth giving an example that neither explains the > > "disregarded" bit nor highligh

Re: substring start position behavior

2024-03-26 Thread Bruce Momjian
On Wed, Mar 6, 2024 at 12:42:09AM -0500, Tom Lane wrote: > I'm kind of inclined to not document this weirdness. I especially > don't think it's worth giving an example that neither explains the > "disregarded" bit nor highlights the dependency on L being given. I retract my doc patch for this.

Drop a partitioned table "side effect"

2024-03-26 Thread gparc
Hello, for a partitioned table, it should be mentioned in the documentation that currently the drop will also silently drop all the partitions underneath. By the way, it's a pity that "cascade" is not considered to be used in such a case. Regards Gilles