Hi,
Actually I read in a blog that this works in PostgreSQL (the author
expected this) and not in MySQL. But to me, the way MySQL is handling
this looks more reasonable.
You may want to read the blog here:
http://www.redhillconsulting.com.au/blogs/simon/archives/000347.html
Regards,
Behi
On 9/10/06, Ron Johnson <ron.l.johnson@cox.net> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Behrang Saeedzadeh wrote:
> > Hi,
> >
> > Shouldn't this create statement trigger an error?
> >
> > create table bar (col1 int not null default null);
> >
> > Shouldn't I be forbidden to insert null values into a non null column?
>
> What happens when you actually try to insert a record?
>
> - --
> Ron Johnson, Jr.
> Jefferson LA USA
>
> Is "common sense" really valid?
> For example, it is "common sense" to white-power racists that
> whites are superior to blacks, and that those with brown skins
> are mud people.
> However, that "common sense" is obviously wrong.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.5 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFFAzbfS9HxQb37XmcRAq6zAJ0SeZKRrHScWhVIwf3F7gZXTdbUQwCgyo7n
> TZd05gua4cmoz4KMe01M5HQ=
> =Zf4H
> -----END PGP SIGNATURE-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
"We can only see a short distance ahead,
but we can see plenty there
that needs to be done." - Alan Turing
"Science is a differential equation. Religion
is a boundary condition" - Alan Turing
Behrang Saeedzadeh
http://www.jroller.com/page/behrangsa
http://my.opera.com/behrangsa