'real' strange problem in 7.1.3

From: reina(at)nsi(dot)edu (Tony Reina)
To: pgsql-hackers(at)postgresql(dot)org
Subject: 'real' strange problem in 7.1.3
Date: 2001-11-09 19:09:23
Message-ID: f40d3195.0111091109.f6d003a@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have a database in PG 7.1.3 with the following schema:

db02=# \d ellipse
Table "ellipse"
Attribute | Type | Modifier
--------------------------+--------------+----------
subject | text |
arm | character(1) |
rep | integer |
exp_date | date |
exp_time | time |
success | integer |
figure_radius | integer |
tube_radius | integer |
cursor_radius | integer |
direction | integer |
ellipse_ratio | real |
exag_ratio | real |
exag_start | integer |
exag_end | integer |
rotation_angle | real |
min_inter_trial_interval | integer |
Index: pkellipse

If I try the command:
db02=# select distinct arm from ellipse where exag_ratio = 1.0;
arm
-----
L
R
(2 rows)

which is correct.

Now I try the same command with a different 'real' field:
db02=# select distinct arm from ellipse where ellipse_ratio = 1.8;
arm
-----
(0 rows)

BUT, if I put the value in quotes (as if it were a string), I get:

db02=# select distinct arm from ellipse where ellipse_ratio = '1.8';
arm
-----
L
R
(2 rows)

which is correct.

This variable ellipse_ratio seems to be the only one of type 'real'
that requires me to use quotes (which doesn't really make sense since
it's not a character or string anyway). exag_ratio and rotation_angle
behave as I would expect a real-typed variable to behave.

db02=# select distinct exag_ratio, ellipse_ratio, rotation_angle from
ellipse;
exag_ratio | ellipse_ratio | rotation_angle
------------+---------------+----------------
1 | 0.56 | 0
1 | 1.8 | 0
(2 rows)

Has anyone seen this behavior before? Perhaps, I'm doing something
wrong here or thinking of this all wrong?

Thanks.
-Tony Reina

Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

db02=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

PG server is RH Linux 7.1 (Seawolf), PIII 400 MHz
Vacuum verbose analyze performed just prior to the searches listed
just to be sure.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-11-09 19:09:31 Re: Call for objections: revision of keyword classification
Previous Message Bradley McLean 2001-11-09 19:01:30 Plpython crashing the backend in one easy step