From: Bruno Wolff III <bruno@wolff.to>
To: plist@horistjr.com
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL Statements question, why I get errors...
Date: Sun, 23 Feb 2003 21:27:52 -0600
Message-ID: <20030224032752.GA8209@wolff.to> (raw)
In-Reply-To: <1519.192.168.100.1.1046038673.squirrel@mail.horistjr.com>
References: <1519.192.168.100.1.1046038673.squirrel@mail.horistjr.com>
On Sun, Feb 23, 2003 at 17:17:53 -0500,
plist@horistjr.com wrote:
> I work a software company and our software is run on databases.. We have
> no problem using MS SQL, DB2, ect... One of my customers wanted to try
> and use POSTGRESQL.. He tried it and is having problems, so I downloaded
> it and am running it on my Red Hat 7.3 box.. I am running version 7.3.2
> of Postgresql.. I hope this is the right place to ask this.. When we
> first launch our program we create several tables... Here is an example
> of one table we create:
>
> create table test (f1 int, f2 char(30), f3 char(30), f4 char(30))
> create unique index itest on test (f1 asc)
>
> The first statement works fine.. However the second statement is when i
> get this error:
>
> Error: parser: parse error at or near "asc" at character 43
>
> Does anyone know of how I can get the last statement to work with this
> database????
Postgresql doesn't allow you to specify directions for indexes. So leave
the "asc" off. For an index on a single column it doesn't really matter
anyway (clustered tables might be an exception).
Currently multicolumn indexes all have to be in the same direction. If you
need one that has mixed directions, the current solution is to create a
new operator class that is backwards from normal and use that operator
class instead of the normal one in the index.
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: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, plist@horistjr.com
Subject: Re: SQL Statements question, why I get errors...
In-Reply-To: <20030224032752.GA8209@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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