I hope you mean 'redundant with "PRIMARY KEY" in example'...
Works out the same way though.
Chris
Neil Conway wrote:
> Log Message:
> -----------
> Minor doc tweak: "NOT NULL" is redundant with "SERIAL" in example.
>
> Modified Files:
> --------------
> pgsql/doc/src/sgml/ref:
> create_domain.sgml (r1.26 -> r1.27)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_domain.sgml.diff?r1=1.26&r2=1.27)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
Christopher Kings-Lynne wrote:
> I hope you mean 'redundant with "PRIMARY KEY" in example'...
Why? SERIAL implies NOT NULL (although PRIMARY KEY does as well, of course).
-Neil
> Why? SERIAL implies NOT NULL (although PRIMARY KEY does as well, of
> course).
Ah yes you're right. I mixed up with the fact that SERIAL no longer
implies UNIQUE...
Chris