Subject RE: [firebird-support] RE: Default column value not applied
Author Rick Debay
Thanks to both.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean
Sent: Thursday, April 18, 2013 4:56 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] RE: Default column value not applied

Rick,

> Is it because I'm explicitly trying to insert NULL for the column?

As Ivan already responded, Yes

The rational is that DEFAULT only applies if the column is not listed in
the INSERT statement, by SQL standard.

Assigning a value of NULL is a direct/positive action, so the DEFAULT
does not apply.


Sean



------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links