postgresql7.1
select idl
from sg_methods
where namespace_id = :namespace_id
order by method_id
select notes
from sg_methods
where method_id = :method_id
select method_id
from sg_methods
where namespace_id = :namespace_id and
lower(method) = lower(:method)
select method_id
from sg_methods
where namespace_id = :namespace_id and proc = :method
select notes
from sg_namespaces
where namespace_id = :namespace_id