Thanls [was: Re: Rewriting Postgres queries]

2002-02-26 Thread Tim Pizey
Thanks a lot Benjamin, that was just what I needed. I have very nearly got http://www.melati.org/ working with MySQL, which will be a big step forward for me and Melati. When I have it working I will let the list know. cheers timp On Tuesday 26 February 2002 16:54, Benjamin Pflugmann wrote: >

Rewriting Postgres queries

2002-02-25 Thread Tim Pizey
Hi, I am trying to make a database-neutral application. What is the MySQL idiom to replace the Postgres EXISTS function? I have two tables: mysql> select * from groupcapability; ++--++ | id | melati_group | capability | ++--++ | 0 |