convert_numeric_to_scalar: unsupported type 354210

From: AgentM <agentm(at)cmu(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: convert_numeric_to_scalar: unsupported type 354210
Date: 2003-06-23 08:10:10
Message-ID: 1BDD614C-A552-11D7-A47E-0030657192DA@cmu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

PostgreSQL 7.3.2:
Here is a piece of a table definition:
CREATE TABLE data
(
id SERIAL PRIMARY KEY,
description TEXT,
ra physreal,
dec physreal,
z physreal,
...);
physreal is the domain of numeric(20,14).

Then I created an index across ra,dec, and z (one index). I really
haven't done anything else to the database. The table has ~290000 rows
and I indexed after inserting the data. Strangely, I can only make
weird selects using these fields. Look:
select dec from data limit 5;
dec
---------------
-1.2378252250
-1.2366515502
-1.2501212847
-1.0732052187
-1.1653486998
(5 rows)

select id from data where dec < 191.456;
id
----
1
2
...this works.

select id from data where dec < 2.0;
ERROR: convert_numeric_to_scalar: unsupported type 354210

This doesn't. The problem persists even when I create individual
indices for each column. It seems this only occurs when I use a number
that is "close" to a value in the column. What's going on and what does
the error mean? Thanks.

><><><><><><><><><
AgentM
agentm(at)cmu(dot)edu

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-06-23 08:29:23 Re: virtual table
Previous Message Anagha Joshi 2003-06-23 05:42:02 Urgent Help : Use of return from function/procedure.