Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!

From: lynch(at)lscorp(dot)com (Richard Lynch)
To: Bruce Tong <zztong(at)laxmi(dot)ev(dot)net>
Cc: Byron Nikolaidis <byronn(at)insightdist(dot)com>, PostgreSQL General <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 22:52:43
Message-ID: v02140b2ab1de7469afee@[207.152.64.133]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-interfaces

At 4:26 PM 7/24/98, Bruce Tong wrote:

>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.

Absolutely. For new (to me) SQL, I point and click at what I think MS
would want me to point and click at, and then look at the SQL and rip out
the crap I know they got wrong, and then run it to see what they got wrong
in the new stuff, and then mess around with bits and pieces of what they
came up with until it's right.

>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.

I especially hate that it doesn't even say "this part is bogus" sometimes.
It says "error near 'from'". *WHICH* from. I could easily have 3 or 4 in
even the simplest query. And god forbid it says "error near ','". How
useless is that?!

Okay, enough bitching, I'll be positive:
psql would be infinitely nicer if it dumped out the query and indicated the
EXACT location of the problem.

--
--
-- "TANSTAAFL" Rich lynch(at)lscorp(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cary B. O'Brien 1998-07-24 23:12:02 Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!
Previous Message Bruce Tong 1998-07-24 21:08:28 Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-07-25 00:18:43 Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!
Previous Message Bruce Tong 1998-07-24 20:22:08 Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y

Browse pgsql-interfaces by date

  From Date Subject
Next Message Cary B. O'Brien 1998-07-24 23:12:02 Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!
Previous Message Bruce Tong 1998-07-24 21:08:28 Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!