[SQL] How can I retrieve an info about function arguments ?

Hello All Consider a function: create function f(varchar(10), decimal(10,1)) returns integer as 'select 1;' language sql; I need to retreive full set of info about argument and return types (for variable length too). How I can get it from system catalog ? For tables columns I can gen an info from p

[SQL] help on sql query

Suppose you have a table T: -- A B -- 1 '111' 2 '222' -- How do you select A and B of the record with A maximum? The desirable result therefore is (2, '222') The two variants I could grow with are: 1) SELECT A, B FR