>> But oracle accepts this one:
>> SQL> select * from re_eintraege where id='';
>> no rows selected
>> because oracle treats the empty string as NULL
>
>Oracle does that for string data, but it doesn't do it for numerics
>does it?  In any case, that behavior is surely non-compliant with
>the SQL spec.

No, oracle accepts this and works correctly with number() datatype. 
However I did not know that in postgres '' was treated as '0'.

Regards,
	Mario Weilguni



Wed, 2 Oct 2002 15:45:51 +0200
"Mario Weilguni" <mario.weilguni@icomedias.com>
Re: Fwd: int type problem in 7.3 
On Wed, 2 Oct 2002, Mario Weilguni wrote:

> >> But oracle accepts this one:
> >> SQL> select * from re_eintraege where id='';
> >> no rows selected
> >> because oracle treats the empty string as NULL
> >
> >Oracle does that for string data, but it doesn't do it for numerics
> >does it?  In any case, that behavior is surely non-compliant with
> >the SQL spec.
> 
> No, oracle accepts this and works correctly with number() datatype. 
> However I did not know that in postgres '' was treated as '0'.

So what would I be selecting in Oracle if I did:

SELECT * FROM mytable WHERE myfield = ''

where myfield is of VARCHAR type?

If you want to select on NULL, whether or not you think the database is more
intelligent than you in determining what you really want, then write your query
to select on NULL. The chances are your database is not actually a mind reader.


-- 
Nigel J. Andrews


Wed, 2 Oct 2002 15:20:03 +0100 (BST)
"Nigel J. Andrews" <nandrews@investsystems.co.uk>
Re: Fwd: int type problem in 7.3
This document:
http://developer.postgresql.org/docs/postgres/release-7-2-3.html

mentions a release date of 2002-10-01 for version 7.2.3.

It isn't on the main website, tough, is it?

Regards,
Michael


Wed, 2 Oct 2002 17:14:46 +0200
"Michael Paesold" <mpaesold@gmx.at>
Release of 7.2.3
On Wed, 2 Oct 2002, Michael Paesold wrote:

> This document:
> http://developer.postgresql.org/docs/postgres/release-7-2-3.html
>
> mentions a release date of 2002-10-01 for version 7.2.3.
>
> It isn't on the main website, tough, is it?

The documentation on the developers website is not necessarily
accurate - especially when it comes to dates.  Documentation is
typically one of the last things finalized and is in a constant
state of change.  That's one of the reasons why the developer
site is separated from the main website - people read things on
the developer site and think they're 100% accurate.  Nothing is
final until it's announced on the announce mailing list and/or
the main website.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
      http://www.camping-usa.com      http://www.cloudninegifts.com
   http://www.meanstreamradio.com       http://www.unknown-artists.com
==========================================================================




Wed, 2 Oct 2002 11:34:21 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
Re: Release of 7.2.3