[development] A little pgsql help

Daniel Convissor danielc at analysisandsolutions.com
Mon Mar 13 17:16:05 UTC 2006

On Thu, Mar 09, 2006 at 04:09:37PM +0100, Piotr Krukowiecki wrote:
> I've also added default values because iirc mysql will insert '' if
> there is no default and no value is provided.

If a default is not specified, the query will fail if the given column is 
not directly specified by the insert query.  It's generally a good idea to 
specify the default values, regardless of which DBMS is being used.


 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409

More information about the development mailing list