:23 AM
Subject: [sqlite] Re: Re: Testing For Empty Table
Rich Shepard <[EMAIL PROTECTED]> wrote:
> I want the latter case. In other words, if there are no records
> where 'category = "natural"' nothing should be returned. It would be
> nice if there was a return
I am curious -- why is the following not a viable option here?
SELECT Count(*) FROM components WHERE category = 'natural';
On 11/4/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Rich Shepard <[EMAIL PROTECTED]> wrote:
> I want the latter case. In other words, if there are no records
> where
Rich Shepard <[EMAIL PROTECTED]> wrote:
I want the latter case. In other words, if there are no records
where 'category = "natural"' nothing should be returned. It would be
nice if there was a return value that told me explicitly "no records
match the where".
You could write
select exists (s
3 matches
Mail list logo