From: | Bruce Tong <zztong(at)laxmi(dot)ev(dot)net> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | lynch(at)lscorp(dot)com, byronn(at)insightdist(dot)com, pgsql-general(at)postgreSQL(dot)org, pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!! |
Date: | 1998-07-24 21:08:28 |
Message-ID: | Pine.LNX.3.95.980724165731.31540B-100000@laxmi.ev.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-interfaces |
> > Since I'm learning SQL in my spare time, I tend to use these feature in MS
> > Access and PgAccess to point me in the right direction or sometimes
> > confirm, or deny my assertions.
> >
> > I like psql, but its not the kind of tool which suggests other
> > alternatives. It just says "this part is bogus." That's fine, but when I
> > fail to get it right after a dozen attempts, its nice to let something
> > else take a stab at it.
>
> Please tell use what else psql can tell the user. We have \h and \d
> commands.
Example:
zztong=> SELECT * FROM school SORT DESC BY school_lname;
ERROR: parser: parse error at or near "desc"
Follow this with 10 more seemingly reasonable attempts at guessing the
correct syntax which all fail. Then I'm off to the books, or maybe I just
run PgAccess and quickly design a view soley to see the SQL.
The problem is not with psql, its with me.
I mean if you want to have psql attempt to suggest the correct syntax
based on my mistakes, I won't complain, but I really don't think it is
needed and I'm certain I would become annoyed with the feature as I became
more experienced.
I have little need for generating SQL "on the fly" as I'm just putting it
into a textfile to be run through psql from a makefile, or I'm burrying it
in a program somewhere. Thus I spend little time with SQL, so I'm learning
it slowly. I don't try to memorize things as I prefer to pick them up via
usage and I try to keep lots of books around.
Bruce Tong | Got me an office; I'm there late at night.
Systems Programmer | Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE |
zztong(at)laxmi(dot)ev(dot)net | -- Joe Walsh for the 21st Century
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Lynch | 1998-07-24 22:52:43 | Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!! |
Previous Message | Bruce Momjian | 1998-07-24 20:47:06 | Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!! |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Lynch | 1998-07-24 22:52:43 | Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!! |
Previous Message | Bruce Momjian | 1998-07-24 20:47:06 | Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!! |