| From: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
|---|---|
| To: | "Andrew Hammond" <andrew(dot)george(dot)hammond(at)gmail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: SQL generator |
| Date: | 2006-07-26 04:00:42 |
| Message-ID: | 36e682920607252100r5fbea54bh31f7a2fa29c7ea26@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> > A typical query then may look like this:
> >
> > Select all 'toys' from 'Walmart' where average_sales(100) > 100000 and
> > avaerage_cost(100,10) <= 1 and item_date between "01-Jan-00" and
> > "01-Jan-06"
See Microsoft's English Query for SQL Server or the SQ-HAL project for examples:
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part9/c3261.mspx?mfr=true
http://www.csse.monash.edu.au/hons/projects/2000/Supun.Ruwanpura/
In general, it's easier to write the SQL than to optimize natural
language-based query translation.
--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 2nd Floor | jharris(at)enterprisedb(dot)com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aaron Bono | 2006-07-26 14:49:25 | Re: About Div |
| Previous Message | Michael Artz | 2006-07-26 02:58:47 | Storing an ordered list |