Re: OT MySQL and PostgreSQL
On Thu, Feb 01, 2007 at 09:19:48PM -0700, Paul E Condon wrote:
> The recent heated discussion as to the relative merits of MySQL and
> PostgresSQL reminded me of a question that I want to ask of RDBMS
> experts, particularly experts who are willing to take a clear
> position. Namely, what do you think of the work of C. J. Date? He
> rejects SQL, as far as I can tell. Is there any support for this
There doesn't seem to be a standard which everyone follows.
> position in the real world? Or in the academic world? What of
> his objection to null 'values'? How does this play out when doing
> mission critical DB? Does it matter? Or are there standards
> techniques for avoiding any need for nulls?
You can always use a default value constraint. I have found strange
results from my queries if using null values.
Don't forget to check that your /etc/apt/sources.lst entries point to
etch and not testing, otherwise you may end up with a broken system once
etch goes stable.