All good points.
The ability to store NULL, and the fact that there is just one kind of
NULL, seem to parallel what has become common and useful in
programming languages. Most support NULL at least for pointers, and
many support it for all data types. It doesn't have to have a defined
meaning to
[EMAIL PROTECTED] (Greg Stark) writes:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
>
>> However, there are often nulls that fall in the category of "who
>> cares?" For those, null is a perfectly acceptable alternative, and
>> there's no need for all the extra work.
>
> There is often a need for sp
Scott Marlowe <[EMAIL PROTECTED]> writes:
> However, there are often nulls that fall in the category of "who
> cares?" For those, null is a perfectly acceptable alternative, and
> there's no need for all the extra work.
There is often a need for special case values. Situations like "subscriptio
On Mon, 2006-07-03 at 11:09, Scott Ribe wrote:
> > Can't the intelligent practitioner simply proceed carefully with
> > queries when nulls are involved?
>
> Yes. The thing is, getting rid of NULL in the real world requires
> decomposing data into so many tables that it would certainly cause more
>
> Can't the intelligent practitioner simply proceed carefully with
> queries when nulls are involved?
Yes. The thing is, getting rid of NULL in the real world requires
decomposing data into so many tables that it would certainly cause more
confusion when it comes time to actually query the data...
On Wed, Jun 28, 2006 at 02:43:03AM -0700, [EMAIL PROTECTED] wrote:
> 'Scuse my broken english and ungrammatical gibberish in my last
> missive. That's what I get for posting before my first cup of
> coffee for the day.
>
> I'm serious about nulls though, and am wondering if Date and Pascal,
> per
y, June 28, 2006 8:45 AM
To: Berend Tober
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Null and Void() - Or, Abandon All Hope Ye Who allow
Well, yes - as I said, using null values gives you more flexibility. But
still, you _can_ shoot yourself in the foot by using them - that's why
On Wed, Jun 28, 2006 at 02:31:20AM -0700, [EMAIL PROTECTED] wrote:
> Date and Pascal hate nulls. One even goes so far as to say that if
> you permit NULLs in a database, then the results from *every* query
> is suspect. So they turn perform backflips suggesting ways to avoid
> nulls. None, so fa
--- Andrew Gould <[EMAIL PROTECTED]> wrote:
> --- Berend Tober <[EMAIL PROTECTED]> wrote:
>
> > Florian G. Pflug wrote:
> > > [EMAIL PROTECTED] wrote:
> > >
> > >> Date and Pascal hate nulls.
> > >
> > > ...the functions described by those functional
> > dependencies are
> > > not require
--- Berend Tober <[EMAIL PROTECTED]> wrote:
> Florian G. Pflug wrote:
> > [EMAIL PROTECTED] wrote:
> >
> >> Date and Pascal hate nulls.
> >
> > ...the functions described by those functional
> dependencies are
> > not required to be defined for every possible
> value - let's say you have
>
Berend Tober wrote:
Florian G. Pflug wrote:
> [EMAIL PROTECTED] wrote:
>
>> Date and Pascal hate nulls.
>
> ...the functions described by those functional dependencies are
> not required to be defined for every possible value - let's say you have
> a function dependency A -> B - meaning th
Florian G. Pflug wrote:
> [EMAIL PROTECTED] wrote:
>
>> Date and Pascal hate nulls.
>
> ...the functions described by those functional dependencies are
> not required to be defined for every possible value - let's say you have
> a function dependency A -> B - meaning that whenever you know the val
[EMAIL PROTECTED] wrote:
Date and Pascal hate nulls. One even goes so far as to say that if you
permit NULLs in a database, then the results from *every* query is
suspect. So they turn perform backflips suggesting ways to avoid nulls.
None, so far, seem appealing.
To me, nulls are quite useful i
'Scuse my broken english and ungrammatical gibberish in my last
missive. That's what I get for posting before my first cup of coffee
for the day.
I'm serious about nulls though, and am wondering if Date and Pascal,
perhaps, are the gibberish ones on this particular issue. The
insistence on no null
14 matches
Mail list logo
