Horton

Thread

  1. BUG #15356: Inconsistent documentation about CREATE TYPE

    PG Bug reporting form <noreply@postgresql.org> — 2018-08-28T12:56:50Z

    The following bug has been logged on the website:

Bug reference:      15356
Logged by:          Lukas Eder
Email address:      lukas.eder@gmail.com
PostgreSQL version: 10.5
Operating system:   Windows
Description:        

Hello,

The CREATE TYPE documentation [1] specifies that enum types without any enum
labels are possible:

    CREATE TYPE name AS ENUM ( [ 'label' [, ... ] ] )

I can confirm this. The following statement works well:

    CREATE TYPE e AS ENUM ();

However, further down in the same documentation page, we can see:

    "Enum types take a list of one or more quoted labels"

It should read "zero or more quoted labels". I suspect this should be
adapted on all documentation pages from PostgreSQL 9.0 onwards. In 8.4, the
documentation was consistent [2]

[1]: https://www.postgresql.org/docs/current/static/sql-createtype.html
[2]: https://www.postgresql.org/docs/8.4/static/sql-createtype.html

  2. Re: BUG #15356: Inconsistent documentation about CREATE TYPE

    Peter Eisentraut <peter.eisentraut@2ndquadrant.com> — 2018-11-13T09:45:36Z

    On 28/08/2018 14:56, PG Bug reporting form wrote:
> The CREATE TYPE documentation [1] specifies that enum types without any enum
> labels are possible:
> 
>     CREATE TYPE name AS ENUM ( [ 'label' [, ... ] ] )
> 
> I can confirm this. The following statement works well:
> 
>     CREATE TYPE e AS ENUM ();
> 
> However, further down in the same documentation page, we can see:
> 
>     "Enum types take a list of one or more quoted labels"
> 
> It should read "zero or more quoted labels". I suspect this should be
> adapted on all documentation pages from PostgreSQL 9.0 onwards. In 8.4, the
> documentation was consistent [2]

Right.  How about the attached patch?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

  3. Re: BUG #15356: Inconsistent documentation about CREATE TYPE

    Lukas Eder <lukas.eder@gmail.com> — 2018-11-13T10:01:45Z

    On Tue, Nov 13, 2018 at 10:45 AM Peter Eisentraut <
peter.eisentraut@2ndquadrant.com> wrote:

> On 28/08/2018 14:56, PG Bug reporting form wrote:
> > The CREATE TYPE documentation [1] specifies that enum types without any
> enum
> > labels are possible:
> >
> >     CREATE TYPE name AS ENUM ( [ 'label' [, ... ] ] )
> >
> > I can confirm this. The following statement works well:
> >
> >     CREATE TYPE e AS ENUM ();
> >
> > However, further down in the same documentation page, we can see:
> >
> >     "Enum types take a list of one or more quoted labels"
> >
> > It should read "zero or more quoted labels". I suspect this should be
> > adapted on all documentation pages from PostgreSQL 9.0 onwards. In 8.4,
> the
> > documentation was consistent [2]
>
> Right.  How about the attached patch?
>

Makes sense, thanks

  4. Re: BUG #15356: Inconsistent documentation about CREATE TYPE

    Peter Eisentraut <peter.eisentraut@2ndquadrant.com> — 2018-11-20T08:53:16Z

    On 13/11/2018 11:01, Lukas Eder wrote:
>     > The CREATE TYPE documentation [1] specifies that enum types
>     without any enum
>     > labels are possible:
>     >
>     >     CREATE TYPE name AS ENUM ( [ 'label' [, ... ] ] )
>     >
>     > I can confirm this. The following statement works well:
>     >
>     >     CREATE TYPE e AS ENUM ();
>     >
>     > However, further down in the same documentation page, we can see:
>     >
>     >     "Enum types take a list of one or more quoted labels"
>     >
>     > It should read "zero or more quoted labels". I suspect this should be
>     > adapted on all documentation pages from PostgreSQL 9.0 onwards. In
>     8.4, the
>     > documentation was consistent [2]
> 
>     Right.  How about the attached patch?
> 
> Makes sense, thanks 

committed

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services