[DB-SIG] Portable method of determining which column wasn't unique?

Eugene V. Dvurechenski jno@glasnet.ru
Mon, 14 Oct 2002 11:24:51 +0400


On Thu, Oct 10, 2002 at 01:48:24PM -0600, Bob Gailer wrote:
> You could :
>   select * from table where unique-column1 = proposed-new-value1
>   select * from table where unique-column2 = proposed-new-value2

 select count(*) from table where unique-column1 = proposed-new-value1
 select count(*) from table where unique-column2 = proposed-new-value2

would be a bit more "portable" (or just handy).
it will return always integer non-null value.

-- 
SY,
jno (PRIVATE PERSON)      [ http://www.glasnet.ru/~jno ]
a TeleRoss techie         [ http://www.aviation.ru/    ]
If God meant man to fly, He'd have given him more money.