recovery

[Keith A. Milner]

On Thursday 01 November 2007 20:39:27 Tarlika Elisabeth Schmitz wrote:
> On Thu, 01 Nov 2007 16:07:03 -0400
>
> Derek Atkins <warlord at MIT.EDU> wrote:
> > Quoting Braindead <Braindead at diablops.com>:
> > >> >>   SELECT * from Split where Split.amount_num/Split.amount_denom
> > >> >> = 1/3;
> >
> > Okay.... Does this work in PG and MySQL?
>
> It works in PostgreSQL.
> No idea about MySQL but I would assume so.

I'm probably missing something obvious, but wouldn't you actually do:

SELECT * from Split
WHERE Split.amount_num = 1 
AND Split.amount_denom=3;

???

-- 
Keith Milner