| Subject | RE: [firebird-support] selecting null still. |
|---|---|
| Author | Johan Visage |
| Post date | 2003-10-09T11:18:52Z |
Hi
Using null in boolean statements (with Firebird) does give you results that
aren't quite as expected. I have a list of results for AND's, OR's, etc.,
but can't seem to find it. Surfice to say that the result you got is not
unique, it is as expected.
Someone else have the details?
J.
If you are not the intended recipient, employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination or copying of this communication and its attachments is strictly prohibited.
If you have received this communication and its attachments in error, please return the original message and attachments to the sender using the reply facility on e-mail.
Internet communications are not secure and therefore the UCLES Group does not accept legal responsibility for the contents of this message. Any views or opinions presented are solely those of the author and do not necessarily represent those of the UCLES Group unless otherwise specifically stated.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses although this does not guarantee that this email is virus free.
**********************************************************=
Using null in boolean statements (with Firebird) does give you results that
aren't quite as expected. I have a list of results for AND's, OR's, etc.,
but can't seem to find it. Surfice to say that the result you got is not
unique, it is as expected.
Someone else have the details?
J.
> -----Original Message-----=**********************************************************
> From: Matt Clark [SMTP:matt.clark@...]
> Sent: Thursday, October 09, 2003 1:14 PM
> To: Firebird list
> Subject: [firebird-support] selecting null still.
>
> hello again.
> Forgot to mention, I realise I can check for null specifically and get
> the result I need but I'm mainly curious to know why null doesn't appear
> to be matched in the original "where".
>
> regards,
> mattc
>
>
> Maplin Electronics Ltd.
> www.maplin.co.uk
>
> This message is intended only for the use of the person(s) ("The intended
> recipient(s)") to whom it is addressed. It may contain information which
> is
> privileged and confidential within the meaning of applicable law. If you
> are not the intended recipient please contact the sender as soon as
> possible.
> The views expressed in this communication may not necessarily be the views
> held by Maplin Electronics Ltd.
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
If you are not the intended recipient, employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination or copying of this communication and its attachments is strictly prohibited.
If you have received this communication and its attachments in error, please return the original message and attachments to the sender using the reply facility on e-mail.
Internet communications are not secure and therefore the UCLES Group does not accept legal responsibility for the contents of this message. Any views or opinions presented are solely those of the author and do not necessarily represent those of the UCLES Group unless otherwise specifically stated.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses although this does not guarantee that this email is virus free.
**********************************************************=