Re: initdb - creating clusters
On Tue, Jul 21, 2020 at 10:40:59AM +0200, Daniel Gustafsson wrote: > > On 21 Jul 2020, at 02:25, Bruce Momjian wrote: > > > > On Thu, Jul 9, 2020 at 03:25:14PM +, PG Doc comments form wrote: > >> looking. For instance the documentation on replication strategies includes > >> proprietary solutions. > > > > Uh, what proprietary solutions are listed in our documentation? > > I think "proprietary" here implies outside-of-core, and we have a few of those > listed in the "Comparison of Different Solutions" section. Oh, OK, those seem fine to me. -- Bruce Momjian https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee
Subscript expressions do not have to evaluate to integers
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-expressions.html Description: Section 4.2.3. Subscripts of the documentation states: > Each subscript is itself an expression, which must yield an integer value. However, the following query works on Postgres 12.1 SELECT (ARRAY[1, 2, 3]::integer[])[1.5]; array --- 2 I believe a more appropriate statement would acknowledge that at least some values undergo an explicit-style conversion to an integer.
Import an XML file
On 22.07.20 01:49, PASCAL CROZET wrote: Hi all, I want to import XML file into PG database table. I've find functions to get the XML content of a cell after imported an XML file with the pg_get_file function. But, I want to explode the XML content to colums. How can I do this ? PG 10 under Ubuntu 18 *_* Cordialement, *Pascal CROZET** * *DBA *- Qualis Consulting •300 Route Nationale 6 – 69760 LIMONEST *_* Pascal, your situation is unclear - at least for me. Please give us more information concerning * your pg_get_file function * a short excerpt of your file * the DDL of your table * what is your understanding of a 'cell'? Is this helpful: https://www.postgresql.org/docs/current/functions-xml.html ? Kind regards, Jürgen Purtz