agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Michael Ehrmantraut <ibmpa!beo.heidelbg.ibm.com!ehrman@ibminet.awdpa.ibm.com>
To: Postgres <postgres%postgres.Berkeley.EDU@ibmpa.awdpa.ibm.com>
Subject: No Effect on defining Indices
Date: Wed, 11 Jan 95 10:00:34 MEZ
Message-ID: <9501110900.AA50439@beo.heidelbg.ibm.com> (raw)

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/

reply

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 using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: ibmpa!beo.heidelbg.ibm.com!ehrman@ibminet.awdpa.ibm.com, postgres%postgres.Berkeley.EDU@ibmpa.awdpa.ibm.com
  Subject: Re: No Effect on defining Indices
  In-Reply-To: <9501110900.AA50439@beo.heidelbg.ibm.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox