>>>>> "Marc" == Marc Sherman <msherman@???> writes:
Marc> Adrian Phillips wrote:
>> I'd still prefer that it were specified as being first or last
>> so that one could at least use ORDER BY <something> and know
>> which row one would get from the table.
Marc> Given that it's always going to be a single row, the correct
Marc> thing to do would be to use ORDER BY and LIMIT 1.
Yes, ie. the administrator has to make sure which row they which
returned to the lookup, otherwise, as David mentioned an arbitary row
will be returned. Actually this should perhaps be documented in some
way as presumably this is the case currently with lookup.
Sincerely,
Adrian Phillips
--
Who really wrote the works of William Shakespeare ?
http://www.pbs.org/wgbh/pages/frontline/shakespeare/
