pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedinclude no validation of XML schema in 8.13.1- the XML Type
4+ messages / 4 participants
[nested] [flat]
* include no validation of XML schema in 8.13.1- the XML Type
@ 2010-01-07 09:32 Andrew Lardinois <lardinois@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Andrew Lardinois @ 2010-01-07 09:32 UTC (permalink / raw)
To: pgsql-docs
Poking around in the 8.5 Devel Documentation section 8.13.1, the XML
Type, I noticed that:
"The xml type does not validate input values against a document type
declaration (DTD), even when the input value specifies a DTD"
I did not notice any mention of validating against XML schema. Now that it
is 2010, the XML schema 1.1 spec is in draft form of one sort or another, is
it safe to leave out mentioning validating against XML schema in the
PostGreSQL documentation. That is, PostGreSQL users should know enough
about XML that if you can't validate against a DTD, why should you be able
to validate against XML schema?
I would tent towards redundancy, and include the XML schema part.
Andrew Lardinois
^ permalink raw reply [nested|flat] 4+ messages in thread
* create table with a CTE
@ 2020-11-14 06:37 PG Doc comments form <noreply@postgresql.org>
2020-11-15 03:55 ` Re: create table with a CTE David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: PG Doc comments form @ 2020-11-14 06:37 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: postgresql@taljaren.se
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/sql-createtableas.html
Description:
Hi.
I think you should include an example on how to create a table from a query
that uses a CTE in the query.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: create table with a CTE
2020-11-14 06:37 create table with a CTE PG Doc comments form <noreply@postgresql.org>
@ 2020-11-15 03:55 ` David G. Johnston <david.g.johnston@gmail.com>
2020-11-15 06:05 ` Re: create table with a CTE Post Gresql <postgresql@taljaren.se>
0 siblings, 1 reply; 4+ messages in thread
From: David G. Johnston @ 2020-11-15 03:55 UTC (permalink / raw)
To: postgresql@taljaren.se, Pg Docs <pgsql-docs@lists.postgresql.org>
On Sat, Nov 14, 2020 at 6:21 AM PG Doc comments form <noreply@postgresql.org>
wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/13/sql-createtableas.html
> Description:
>
> Hi.
> I think you should include an example on how to create a table from a query
> that uses a CTE in the query.
>
[shrug]
The obvious attempt to specify:
create table cte_tbl as
WITH cte (val) AS (select 1)
SELECT * FROM cte;
works so I'm not really sure that such an example adds valuable insight.
I suppose that adding an example, and some explanation, that one can get
update/delete output to populate the newly created table by wrapping them
in a CTE would provide the user a suggestion on how to overcome the fact
that simply writing the following doesn't work.
create table cte_update as
update other_table set value = 2
returning *;
That isn't something we make a concerted effort to accomplish but it also
isn't avoided.
David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: create table with a CTE
2020-11-14 06:37 create table with a CTE PG Doc comments form <noreply@postgresql.org>
2020-11-15 03:55 ` Re: create table with a CTE David G. Johnston <david.g.johnston@gmail.com>
@ 2020-11-15 06:05 ` Post Gresql <postgresql@taljaren.se>
0 siblings, 0 replies; 4+ messages in thread
From: Post Gresql @ 2020-11-15 06:05 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org
On 2020-11-15 04:55, David G. Johnston wrote:
> On Sat, Nov 14, 2020 at 6:21 AM PG Doc comments form
> <noreply@postgresql.org <mailto:noreply@postgresql.org>> wrote:
>
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/13/sql-createtableas.html
> Description:
>
> Hi.
> I think you should include an example on how to create a table
> from a query
> that uses a CTE in the query.
>
>
> [shrug]
> The obvious attempt to specify:
>
> create table cte_tbl as
> WITH cte (val) AS (select 1)
> SELECT * FROM cte;
>
> works so I'm not really sure that such an example adds valuable insight.
That is probably a totaly worthless example for a experienced user.
The only insight would be for a new user that "oh, I can do it like that".
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-11-15 06:05 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-01-07 09:32 include no validation of XML schema in 8.13.1- the XML Type Andrew Lardinois <lardinois@gmail.com>
2020-11-14 06:37 create table with a CTE PG Doc comments form <noreply@postgresql.org>
2020-11-15 03:55 ` Re: create table with a CTE David G. Johnston <david.g.johnston@gmail.com>
2020-11-15 06:05 ` Re: create table with a CTE Post Gresql <postgresql@taljaren.se>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox