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/
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
