Thread: descending index
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
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
"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
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
>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