pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
index on int8 in PG 6.4.2
2+ messages / 2 participants
[nested] [flat]

* index on int8 in PG 6.4.2
@ 1999-05-24 23:46  Mirek Budzanowski <mirekb@tcs.uni.wroc.pl>
  0 siblings, 1 reply; 2+ messages in thread

From: Mirek Budzanowski @ 1999-05-24 23:46 UTC (permalink / raw)
  To: pgsql-sql@hub.org


Hello,

I got a table createtd with command:
create table test (t int8);

When I try:
create index i_test on test(t);
I get error:
ERROR:  Can't find a default operator class for type 20.

How can I define a default operator for int8???
When I am doing select * from test where t > 4, etc.
it works. 

Anyone have any idea how to define a index ont int8 field?

Mirek

--
Mirek Budzanowski; P.O. box 1739; 51-161 Wroclaw 8; Poland
Tel. +48 602 306674     http://www.tcs.uni.wroc.pl/~mirekb




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] index on int8 in PG 6.4.2
@ 1999-05-25 00:38  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Mirek Budzanowski <mirekb@tcs.uni.wroc.pl>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 1999-05-25 00:38 UTC (permalink / raw)
  To: Mirek Budzanowski <mirekb@tcs.uni.wroc.pl>; +Cc: pgsql-sql@hub.org

Mirek Budzanowski <mirekb@tcs.uni.wroc.pl> writes:
> Anyone have any idea how to define a index ont int8 field?

Postgres 6.4 doesn't have support for indexes on int8.

In theory you could add it for yourself (there is some documentation
about index operators in the Developer's Guide) but it's not a simple
job.  You would probably be better off to wait for 6.5, which does
have int8 index support...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-05-25 00:38 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-05-24 23:46 index on int8 in PG 6.4.2 Mirek Budzanowski <mirekb@tcs.uni.wroc.pl>
1999-05-25 00:38 ` Tom Lane <tgl@sss.pgh.pa.us>

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