Skip site navigation (1) Skip section navigation (2)

Re: bool type could be better documented

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: <xxiii(at)cyberdude(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: bool type could be better documented
Date: 2001-02-13 22:23:07
Message-ID: Pine.LNX.4.30.0102132315390.1615-100000@peter.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org writes:

> The documentation in both 7.1 and 7.0.3 talks about the bool type but
> both fail to actually mention the name(s) of the type in the section
> on booleans.
> presumably its called 'boolean' based on the description, but it could
> be clearer. one has to refer to table 3-1 to make sure. (for instance,
> the description of 'money' makes it clear via the table, that the type
> is called 'money').  perhaps if the first sentence were changed from
> "Postgres supports the SQL99 boolean type" to "Postgres supports the
> SQL99 <BOLD>boolean</BOLD> type" (or quotes or something; whenever its
> being used as a name, and not to represent "concept of true/false
> state").

Well, actually it says

    <productname>Postgres</productname> supports the
    <acronym>SQL99</acronym> <type>boolean</type> type.
    <type>boolean</type> can have one of only two states: 'true' or
    'false'.  A third state, 'unknown', is represented by the SQL NULL
    state. <type>boolean</type> can be used in any boolean expression,
    and boolean expressions always evaluate to a result compatible
    with this type.

but <type> doesn't actually alter the font.  Maybe monospaced would be
appropriate?  Actually, the issue might be served better by showing an

> Its a bit like talking about a car which is named car... its
> obvious to the writer, but to the reader they just assume "concept of
> automobile" whenever they hear car, and never realize that its
> actually named "car".

I understand.

Peter Eisentraut      peter_e(at)gmx(dot)net

In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-02-13 22:49:11
Subject: bug #126, referential integrity makes big LOCK
Previous:From: pgsql-bugsDate: 2001-02-13 21:51:46
Subject: alter table rename and ruminations on referential integrity

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group