From: Tim Pizey <tim@paneris.co.uk>
To: pgsql-sql@postgresql.org
Subject: Invalid (null) int8, can't convert to float8
Date: Mon, 19 Mar 2001 17:27:24 +0000
Message-ID: <3AB6417C.A4932BA4@paneris.co.uk> (raw)
Hi,
I have been lurking for a while and am very appreciative of the effort
put in by the answers on this list, and for psql itself.
I am using Postgres version 7.0.2
I have a table defined thus:
CREATE TABLE "chapter" (
"id" int4 NOT NULL,
"book" int4 NOT NULL,
"sequence" int4 NOT NULL,
"textid_old" int4,
"indexdate" timestamp,
"title" text NOT NULL,
"path" text NOT NULL,
"filename" text NOT NULL,
"part" text,
"lastencached" timestamp,
"longtitle" text,
"layout" int4,
"messageboard" int4,
"textid" int8
);
CREATE UNIQUE INDEX "chapter_id_index" on "chapter" using btree ( "id"
"int4_ops" );
CREATE INDEX "chapter_book_index" on "chapter" using btree ( "book"
"int4_ops" );
CREATE INDEX "chapter_sequence_index" on "chapter" using btree (
"sequence"
"int4_ops" );
CREATE UNIQUE INDEX "chapter_textid_index" on "chapter" using btree (
"textid" "int8_ops" );
If there is a a record with a Null textid in the table then psql reports
the error:
Invalid (null) int8, can't convert to float8
to a query of the form
select id from chapter where textid = 9057599501;
It does seem as though the textid in the query needs to be large to
produce the error.
Can anyone suggest what is going on?
I have, temporary, fixed the problem by eliminating all records with a
null textid, but
null is a sensible value, so it will re-occur.
thanks in advance
timp
--
Member of http://www.paneris.org/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: tim@paneris.co.uk
Subject: Re: Invalid (null) int8, can't convert to float8
In-Reply-To: <3AB6417C.A4932BA4@paneris.co.uk>
References: <3AB6417C.A4932BA4@paneris.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox