[Lazarus] Lazarus, Jedi etc.

[Henry Vermaak]

On Mon, Jul 15, 2013 at 04:37:35PM +0200, Michael Van Canneyt wrote:
> On Mon, 15 Jul 2013, Henry Vermaak wrote:
> >Could you explain why the above is bad for those of us that aren't DB
> >experts?  To my untrained eye it looks fairly plausible, so I'm
> >obviously missing something.
> 
> Simple. The statement
> 
> create table a (b int not null, c int not null);
> 
> creates a table called 'a', in which the fields b and c are required.
> that is, they cannot be NULL.
> 
>  mysql> insert into a (b) values (1);
> 
> Attempts to insert a record with value NULL for C, which is
> explicitly forbidden by the definition of the table.

0 != NULL, it's inserting the default value for the field, which seems
to be 0 for an integer field.

Does e.g. postgres error on an insert statement like this?

Henry