Thread: descending index

descending index

From
"Pirtea Calin"
Date:
I'm creating a small database, for test puproses, in PostgreSQL
and after some unsuccesfull attempts to find the answer in the
pdf documentation i've turn to this newsgroup for help.

I have read (partialy) the reference guide from the official site
and stoped at topic create index. I can't find no mention about
creating descending indexes. Is there such a thing as descending
index in PostgreSQL or is it not needed?
If yes where can i find the propper documentation on how to create one?

I spent the last days rewriting some scripts that i used to create
a database in Firebird in order to be able to use them in PostgreSQL.
My final purpose is to write a small test application that can compare
results between Firebird and PostgreSQL.

Since Firebird and PostgreSQL are quite diferent in too many ways
i won't do some complicated database design and i try to use features
that are similar in both RDBMS. I know a lot of users are interested
in a comparison between these 2 database servers since they are both
Open Source and cost free so i decided to make this test application.
I would also appreciate some hints into creating a test sample in such
manner that it would be usefull for many users as a comparison for
speed, number of features, and so on ...


TIA.

--
Best regards,
Aplication Developer
Pirtea Calin Iancu
S.C. SoftScape S.R.L.
pcalin@rdsor.ro


Re: descending index

From
Björn Lundin
Date:
On Wed, 27 Feb 2002 16:14:48 +0200
"Pirtea Calin" <pcalin@rdsor.ro> wrote:

> I'm creating a small database, for test puproses, in PostgreSQL
> and after some unsuccesfull attempts to find the answer in the
> pdf documentation i've turn to this newsgroup for help.
>
> I have read (partialy) the reference guide from the official site
> and stoped at topic create index. I can't find no mention about
> creating descending indexes. Is there such a thing as descending
> index in PostgreSQL or is it not needed?
> If yes where can i find the propper documentation on how to create one?

Can't you use 'order by' with 'asc or desc' ?
/Björn

Re: descending index

From
Tom Lane
Date:
"Pirtea Calin" <pcalin@rdsor.ro> writes:
> Is there such a thing as descending
> index in PostgreSQL or is it not needed?

It's not needed.

            regards, tom lane

Re: descending index

From
Jean-Michel POURE
Date:
Le Mercredi 27 Février 2002 15:14, Pirtea Calin a écrit :
> I spent the last days rewriting some scripts that i used to create
> a database in Firebird in order to be able to use them in PostgreSQL.
> My final purpose is to write a small test application that can compare
> results between Firebird and PostgreSQL.

PostgreSQL does not offer ascending/decending indexes, probably because they
are not really needed. Why do you need them? Maybe we can set up a more
powerfull solution based on triggers, views, PLpgSQL, etc...

Maybe you should try pgAdmin2, Windows PostgreSQL GUI
(http://pgadmin.postgresql.org). It has an online PostgreSQL 7.2 guide in
user help. You may import your existing Firebuid application and rewrite it.

Feel free to send us more information about your test DB.
Cheers, Jean-MIchel POURE

Re: descending index

From
"Pirtea Calin"
Date:
>From: "Jean-Michel POURE"
>Maybe you should try pgAdmin2, Windows PostgreSQL GUI
>(http://pgadmin.postgresql.org). It has an online PostgreSQL 7.2 guide in
>user help. You may import your existing Firebuid application and rewrite
it.

:) Thanks. That's what i use to inspect the database. But i access it from
Delphi. I find it a very nice tool though. For Delphi i use Zeos Access
components because they allow me to connect both to Firebird and PostgreSQL.

>Feel free to send us more information about your test DB.
>Cheers, Jean-MIchel POURE

Count on that. For the moment i'm in the faze of inserting (pumping) data to
the
server (SUSE 7.3; Last versions from PostgreSQL and Firebird at the end of
last
year) while i'm reading the documentation from PostgreSQL site. After that
i'll start
making tests. I'm more interested in features compare because i expect
similar results
(very similar) in speed, so is more a question of when is one recomended and
when
is the other.

I already have a question but i'll post it in a new mail.

Thank you very much for the answer.


Best regards,
Aplication Developer
Pirtea Calin Iancu
S.C. SoftScape S.R.L.
pcalin@rdsor.ro