Re: Distributed foreign keys (was Re: Category Types)

"Paul Vernon" <paul.vernon_at_ukk.ibmm.comm> wrote in message news:bcrtus$1qpu$1_at_gazette.almaden.ibm.com...
> "Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message
> news:6I4Ia.17$t13.195_at_news.oracle.com...
> >
> > "Paul Vernon" <paul.vernon_at_ukk.ibmm.comm> wrote in message
> > news:bcq3u8$201s$1_at_gazette.almaden.ibm.com...
> > > Hugh Darwen has a proposal for such "distributed foreign key"
shorthands
> > in
> > > this presentation.
> > >
> > >
> >

http://www.hughdarwen.freeola.com/TheThirdManifesto.web/Missing-info-without
> > -nulls.pdf
> >
> > Regarding the presentation, for the person who earns no salary, can't we
> > just assume that the salary is 0? (That is what I thought 0 number
> > abstraction is for;-)
>
> Can you pay me $0.00 for the answer? Check will be fine, just make it out
for
> zero.

No problem, I keeping my payment records in the database already:

table questions (

    question_asked String,
    person_answered String,
    payment Money,
    payment_type String

• the answer provided doesn't matter );

insert into questions values ('can we assume that the salary is 0?', 'Paul Vernon', to_money('$0'), 'check'); Received on Fri Jun 20 2003 - 00:32:10 CEST