Adrian Phillips wrote: >>>>>> "Marc" == Marc Sherman <[EMAIL PROTECTED]> 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 -- ## List details at http://www.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
