Re: Checking for the existence of a certain row.

[M.W. Koskamp]

>
> SYBASE::
> select 1 where exists
> ( select * from some_table where some_column = 'some_value')
>
> Anyway, it's obviously not as portable as any of the other methods, but
I'm
> just trying to brainstorm the possibilities of the best methods for an
> existence lookup.

Most portable is:

select count(*) from some_table where some_column = 'some_value'

As i posted before.
Will give you an integer.
Any integer that is not 0 is a true value to Perl.

Maarten.