Re: Fwd: int type problem in 7.3

>> 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

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

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

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(at)michvhf(dot)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
==========================================================================