SQL Statements question, why I get errors...
От | |
---|---|
Тема | SQL Statements question, why I get errors... |
Дата | |
Msg-id | 1519.192.168.100.1.1046038673.squirrel@mail.horistjr.com обсуждение исходный текст |
Ответы |
Re: SQL Statements question, why I get errors...
Re: SQL Statements question, why I get errors... |
Список | pgsql-sql |
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???? Thanks...
В списке pgsql-sql по дате отправления: