Re: PostgreSQL Certification - Mailing list pgsql-advocacy

From Jan Wieck
Subject Re: PostgreSQL Certification
Date
Msg-id 3FA1C330.7010500@Yahoo.com
Whole thread Raw
In response to Re: PostgreSQL Certification  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-advocacy
Christopher Browne wrote:
> Jon.Ericson@jpl.nasa.gov (Jon Ericson) writes:
>> Christopher Browne <cbbrowne@acm.org> writes:
>> [an outline of a tutorial]
>>>   - Why avoid NULLs?
>>
>> I'm curious about the answer to that question.  Is it a relational
>> database theory problem or PostgreSQL implementation issue?  Or do
>> you just talk about inappropriate uses of NULL?
>
> It somewhat parallels the infamous "GOTO considered harmful" that
> caused great controversy around the ACM for many years after Dijkstra
> sent in a letter by that title, and yes, it's an issue of "relational
> database theory."

And I still think avoiding GOTO alltogether is a good thing. Instead the
language is supposed to support COMEFROM, which you put at the place
where you want to continue when the program had reached some other
place. You can think of it much like an exception handler, the exception
being that the program survived to a point where you not really expected
it to get to.

Fortunately PostgreSQL has this even down on the per row level in form
of the BEFORE TRIGGER returning NULL and INSTEAD rewrite rules.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-advocacy by date:

Previous
From: Christopher Browne
Date:
Subject: Re: PostgreSQL Certification
Next
From: Jon Ericson
Date:
Subject: Re: PostgreSQL Certification