Confusion in section 8.7.3. Type Safety

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: dejan(dot)spasic(at)bitweise(dot)biz
Subject: Confusion in section 8.7.3. Type Safety
Date: 2025-09-23 07:09:42
Message-ID: 175861138289.858.2065605212405176332@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/datatype-enum.html
Description:

In section 8.7.3. Type Safety one can observe a the following statement in
the examples.

INSERT INTO holidays(num_weeks,happiness) VALUES (2, 'sad');

This is somewhat confusing since type happiness doesn't contain 'sad'. I
would suggest to remove the statement or to add an enum 'sad' in type
happiness.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David Rowley 2025-09-23 11:14:10 Re: Confusion in section 8.7.3. Type Safety
Previous Message jian he 2025-09-18 09:03:10 Re: CREATE TABLE LIKE(INCLUDING COMMENTS) description ignored STATISTICS