Subject | Re: string concatination, triggers |
---|---|
Author | dianeb77@hotmail.com |
Post date | 2001-04-12T00:13:12Z |
--- In ib-support@y..., Helen Borrie <helebor@d...> wrote:
Ah, but then you must excuse me. I hadn't realized you were being
academic (or are academic?), otherwise I, too, would not have bothered
to respond. Starting off with my feet on the ground (or as close as
is possible) dealing with a problem in SQL-land, then suddenly
awakening to find myself lost in math-magic-land was a bit of a shock
to my delicate system.
Perhaps I will recover. [Or perhaps the lesson here is to stay safe
and never bother to respond? ... Ah yes, that seems to work. :-)]
Cheers,
db
> At 01:00 AM 10-04-01 +0000, you [that would be me] wrote:else] wrote:
> >--- In ib-support@y..., Helen Borrie <helebor@d...> wrote:
> > > At 11:08 AM 09-04-01 +0200, you [that would be someone
> > > >Helen,<...>
> > > >
> > > > > >If I define a computed column like the one in documents:
> > > > > >full_name computed by (first_name || ' ' || last_name)
> > > > > >It works only if non of the two composing columns is null.
> >Otherwise, the
> > > > > >value is null if any of the two is null.
> > > > >
> > > > > Correct. Value + NULL evaluates to false.
> > > >
> > > >As a matter of fact, Value + NULL evaluates to NULL.
> > > >I guess you meant that.
> > >
> > > No, I meant what I said.
> >
> >Then I don't understand your reply.
> >
>to respond). <...>
> Au contraire (being academic here, for which reason I didn't bother
Ah, but then you must excuse me. I hadn't realized you were being
academic (or are academic?), otherwise I, too, would not have bothered
to respond. Starting off with my feet on the ground (or as close as
is possible) dealing with a problem in SQL-land, then suddenly
awakening to find myself lost in math-magic-land was a bit of a shock
to my delicate system.
Perhaps I will recover. [Or perhaps the lesson here is to stay safe
and never bother to respond? ... Ah yes, that seems to work. :-)]
Cheers,
db