Re: [SQL] SELECT with Function

2004-10-09 Thread Paulo Nievierowski
Dear Marcin Thanks for your reply. My created function running well as exposed by you in ttt() function and this is no problem. I need extend this query. See: TableA prod_idnumeric(10) prod_name varchar(40) ... My function, as your ttt(), return 3 values and value prod_id from TableA m

Re: [SQL] SELECT with Function

2004-10-03 Thread Marcin Piotr Grondecki
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paulo Nievierowski wrote: | PS: Excuses my poor english. Your english is excellent. MY is poor!! | I create plpgsql function "myfunc(integer)" thats returns of type | record with values from table X (the function decides what record must | be select). T