> Thanks for that Ian, worked a treat. However, can someone tell me why
>
> select n.ntimestamp, n.nmid from news n where n.ntimestamp > current_time -
> interval '5 minutes';
>
> works while
>
> select n.ntimestamp, n.nmid, m.mfname, m.mlname
> from news n, members m
> order by ntimestamp desc
> limit 1
> where (n.nmid = m.mid) and
> (n.ntimestamp > current_time - interval '5 minutes');
>
> has a parse error at or near "where"
The where clause should go between the from and order by.
