[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.

--Dan

-- 
 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
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409


More information about the development mailing list