[firebird-support] What is more effective execute block or select?

 

I would know whats methods is more effective, per exemple:

To know if itens exists or not, select:
select
  case
    when exists(select 1 from cv_itens  where id_cv=51716)
    then 'Y'
    else 'N'
  end as existe_itens
from rdb$database

OR using block execute:
execute block
returns(exist varchar(1))
as
begin
  exist='N';
  if (exists(select 1 from cv_itens  where id_cv=51716)) then exist='Y';
  suspend;
end

I think that first method using rdb$database as source, checking permissions and others things and second method is not and more powerfull using psql.

I would like to know what you guys think about.

__._,_.___

---

Posted by: hamacker <sirhamacker@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___