SQL Statements question, why I get errors... - Mailing list pgsql-sql

From
Subject SQL Statements question, why I get errors...
Date
Msg-id 1519.192.168.100.1.1046038673.squirrel@mail.horistjr.com
Whole thread Raw
Responses Re: SQL Statements question, why I get errors...  (Josh Berkus <josh@agliodbs.com>)
Re: SQL Statements question, why I get errors...  (Bruno Wolff III <bruno@wolff.to>)
List 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 by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Help with query involving aggregation and joining.
Next
From: "James Cooper"
Date:
Subject: syntax question