Subject | Re: exists(EXECUTE STATEMENT ... |
---|---|
Author | Svein Erling Tysvær |
Post date | 2004-08-13T09:00:15Z |
--- In firebird-support@yahoogroups.com, Bjoern Reimer wrote:
(for?) select 1 from rdb$database where exists(select "Id"...
would be quicker.
Set
> Hi Helen,If this query potentially could return a huge number, then a
>
> >>Hi,
> >>
> >> (Firebird 1.5.1 CS on Linux)
> >> in PSQL the following statement doesn't work:
> >>
> >> [...]
> >> "SQL" = 'SELECT "Id" FROM "SomeTable" WHERE "Fieldname" ='||
> >> "ParameterOfSP";
> >>
> >> IF (not exists(EXECUTE STATEMENT "SQL")) THEN
>
> I 've changed the query to a select count("Id")... INTO :"Counter"
> which perfectly works.
(for?) select 1 from rdb$database where exists(select "Id"...
would be quicker.
Set