public inbox for [email protected]
help / color / mirror / Atom feedVERY SMALL DOC BUG: http://www.postgresql.org/idocs/index.php?sql-createtable.html
2+ messages / 2 participants
[nested] [flat]
* VERY SMALL DOC BUG: http://www.postgresql.org/idocs/index.php?sql-createtable.html
@ 2002-09-03 15:12 Janning Vygen <[email protected]>
2002-09-03 18:59 ` Re: VERY SMALL DOC BUG: http://www.postgresql.org/idocs/index.php?sql-createtable.html Bruce Momjian <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Janning Vygen @ 2002-09-03 15:12 UTC (permalink / raw)
To: pgsql-docs
Hi,
In document
http://www.postgresql.org/idocs/index.php?sql-createtable.html
it says (Parameters, third section):
NOT NULL
The column is not allowed to contain NULL values. This is
equivalent to the column constraint CHECK (column NOT NULL).
At the end it must say:
CHECK (column IS NOT NULL).
^^
thanks for maintaining/developing postgresql!! Great database!
kind regards,
janning
--
PLANWERK 6 /websolutions
Herzogstraße 86
40215 Düsseldorf
fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: VERY SMALL DOC BUG: http://www.postgresql.org/idocs/index.php?sql-createtable.html
2002-09-03 15:12 VERY SMALL DOC BUG: http://www.postgresql.org/idocs/index.php?sql-createtable.html Janning Vygen <[email protected]>
@ 2002-09-03 18:59 ` Bruce Momjian <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2002-09-03 18:59 UTC (permalink / raw)
To: Janning Vygen <[email protected]>; +Cc: pgsql-docs
Looks like this is already fixed in 7.3, due out in a few months:
A not-null constraint is always written as a column constraint. A
not-null constraint is equivalent to creating a check constraint
<literal>CHECK (<replaceable>column_name</replaceable> IS NOT
NULL)</literal>, but in <productname>PostgreSQL</productname>
---------------------------------------------------------------------------
Janning Vygen wrote:
> Hi,
>
> In document
> http://www.postgresql.org/idocs/index.php?sql-createtable.html
>
> it says (Parameters, third section):
>
> NOT NULL
> The column is not allowed to contain NULL values. This is
> equivalent to the column constraint CHECK (column NOT NULL).
>
> At the end it must say:
>
> CHECK (column IS NOT NULL).
> ^^
>
> thanks for maintaining/developing postgresql!! Great database!
>
> kind regards,
> janning
>
> --
> PLANWERK 6 /websolutions
> Herzogstra?e 86
> 40215 D?sseldorf
>
> fon 0211-6015919
> fax 0211-6015917
> http://www.planwerk6.de
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-09-03 18:59 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-09-03 15:12 VERY SMALL DOC BUG: http://www.postgresql.org/idocs/index.php?sql-createtable.html Janning Vygen <[email protected]>
2002-09-03 18:59 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox