X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C78FA9F95E3 for ; Tue, 25 Jul 2006 18:04:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 94885-02 for ; Tue, 25 Jul 2006 18:04:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 936899F9316 for ; Tue, 25 Jul 2006 18:04:05 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 178C4308EE; Tue, 25 Jul 2006 23:04:04 +0200 (MET DST) From: Chris Browne X-Newsgroups: pgsql.sql Subject: Re: SQL generator Date: Tue, 25 Jul 2006 20:39:16 +0000 Organization: cbbrowne Computing Inc Lines: 21 Message-ID: <60k661a07f.fsf@dba2.int.libertyrms.com> References: <1153395978.590189.261100@75g2000cwc.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:xYh03OIX8RW+KE0a/uQP88gi0G8= To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.255 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200607/311 X-Sequence-Number: 25885 "Bit Byter" writes: > I would like to know what the underlying SQL statement will look > like, so that I can use this knowlege to build a generic parser that > creates SQL statements from the "English like" text, using the > syntax I described above. I seem to recall that Lotus tried doing this once upon a time with trying to build an "english-like" interface for doing "business intelligence-like" queries against spreadsheets. Nobody likely remembers HAL; it was underwhelmingly useful. In effect, anyone that was skilful enough at composing "English-like" queries to get HAL to work was likely to find the "native" methods more convenient. -- let name="cbbrowne" and tld="acm.org" in String.concat "@" [name;tld];; http://cbbrowne.com/info/linuxxian.html "La Cicciolina [...] Electing her was an interesting contrast to the situation in the UK: In Italy they elect a representative from the sex industry. In the UK, they elect their clients." -- Peter Gutmann