Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199501110901.BAA18026@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: ibmpa!beo.heidelbg.ibm.com!ehrman@ibminet.awdpa.ibm.com (Michael Ehrmantraut)
Message-Id: <9501110900.AA50439@beo.heidelbg.ibm.com>
Subject: No Effect on defining Indices
To: postgres%postgres.Berkeley.EDU@ibmpa.awdpa.ibm.com (Postgres)
Date: Wed, 11 Jan 95 10:00:34 MEZ
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Wed, 11 Jan 95 01:01:06 -0800
Resent-XMts: smtp

Hello everyone,

I hope there is someone that can help me.
I have installed Postgres 4.2 on AIX. It works well since two or
three month. But now, I get some problems on defining Indices.

When I do this with the command "define index ... using btree ..."
on a normal attribut (int4) by using the default operators "int4_ops"  
I am getting no effect. POSTGRES gives me no errors, but when I 
start a "retrieve"-command the result is not ordered.

When executing the example "chapter13" in ".../src/examples" all works
well, but the last output is not o.k. The operator <<& works well and
don't print the line with "number=-10000". But the output is not ordered.

Are there any hints in the manual I didn't see ?
Did I make a basic mistake ?
Doesn't Version 4.2 support indices anymore ?

Please help me

	Michael Ehrmantraut
	ehrman@beo.heidelbg.ibm.com


==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/