On Thu, Jan 10, 2008 at 02:19:43PM +1100, Phillip Smith wrote: > SELECT * > > FROM Individual > > LIMIT 3
Note that you will have to add an 'order by' clause to guarantee predictable results... -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen [EMAIL PROTECTED] http://www.xs4all.nl/~reinoud __________________________________________________ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match