Re: SQL Statements question, why I get errors...

> "Plist,"
>
>> 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:
>
> You're in for a long, painful process if you think you can port a
> production  application to PostgreSQL (or between *any* two database
> platforms) without  an expert DBA.   Perhaps you should consider a
> consultant?
>
>> create table test (f1 int, f2 char(30), f3 char(30), f4 char(30))
>> create unique index itest on test (f1 asc)
>
> Some databases (MSSQL) require seperate indexes for ascending (ASC) and
> descending (DESC) sorts.  Postgresql does not; since 7.2.0, we have been
> able  to use the same index for both types of sorts.  As such,
> Postgresql does not  support the "ASC" syntax in index creation.  Simply
> change your statement to:
>
> create unique index itest on test (f1);
>
> ... and it will work.
>
I have tried that and yes it did work..  Just don't know if I want to tell
my programmers to go in change all there code for postgresql...  Thanks
for the info..

Ron

> --
> Josh Berkus
> Aglio Database Solutions
> San Francisco




---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx