Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.8.8/8.7.5) with ESMTP id UAA20392; Fri, 24 Jul 1998 20:00:55 -0400 (EDT) Received: (from maillist@localhost) by candle.pha.pa.us (8.8.5/8.8.5) id TAA00236; Fri, 24 Jul 1998 19:58:02 -0400 (EDT) From: Bruce Momjian Message-Id: <199807242358.TAA00236@candle.pha.pa.us> Subject: Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!! In-Reply-To: <199807242312.TAA06544@access2.digex.net> from "Cary B. O'Brien" at "Jul 24, 1998 7:12: 2 pm" To: cobrien@access.digex.net (Cary B. O'Brien) Date: Fri, 24 Jul 1998 19:58:02 -0400 (EDT) Cc: zztong@laxmi.ev.net, lynch@lscorp.com, byronn@insightdist.com, pgsql-general@postgreSQL.org, pgsql-interfaces@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL43 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > Hmm Did you try... > > cary=> \h select > Command: select > Description: retrieve tuples > Syntax: > select [distinct on ] [as ], ... [as ] > [into [table] ] > [from ] > [where ] > [group by ] > [order by [ASC | DESC] [using ], ... ] > [union [all] select ...]; I am working on uppercasing the keywords, so it will be much clearer. The use of <> is really bogus. I will look into reporting the place of the error, as well as the word. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)