Re: SELECT with REAL...

On Feb 6, 2006, at 7:30 , Philippe Ferreira wrote:

> For example, the following command always returns 0 row, even if
> rows with myreal=10.5 do exist :
>     SELECT * FROM mytable WHERE myreal=10.5;
>
> Where am I wrong ?!

Without seeing a more complete example, it's hard to say. It works
for me here:
create table real_test
(
     real_label text primary key
     , real_value real not null unique
);

copy real_test (real_label, real_value) from stdin;
foo    1.2
bar    10.53
baz    10.5
bat    -54.3
\.


test=# select * from real_test;
real_label | real_value
------------+------------
foo        |        1.2
bar        |      10.53
baz        |       10.5
bat        |      -54.3
(4 rows)

test=# select * from real_test where real_value >= 10.5;
real_label | real_value
------------+------------
bar        |      10.53
baz        |       10.5
(2 rows)

test=# select * from real_test where real_value = 10.5;
real_label | real_value
------------+------------
baz        |       10.5
(1 row)

test=# select version();

version
------------------------------------------------------------------------
----------------------------------------------------------------------
PostgreSQL 8.1.0 on powerpc-apple-darwin8.3.0, compiled by GCC
powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 (Apple Computer, Inc.
build 5026)
(1 row)


Michael Glaesemann
grzm myrealbox com