Adrian Phillips wrote:
>>>>>> "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.
No. At least for a pgsql lookup, it is perfectly happy to return
multiple rows.
Cheers,
Jeremy
