Thread: BUG #2456: How to write user defined functions in Postgress sql
The following bug has been logged online: Bug reference: 2456 Logged by: Vivekananda Email address: r.vivekanandaswamy@yahoo.co.in PostgreSQL version: 8.1 Operating system: Windows-2000 Description: How to write user defined functions in Postgress sql Details: Hai, I have good knowledge in Oracle-Pl/sql.But,now my client wants to use PGSQL.Now i am sending function as below. create or replace function fun_emp(eno integer) returns varchar as v_name varchar; begin select ename into v_name from emp where empno=eno; return v_name; end; / SQL>Select fun_emp(7788) from dual; SQL>Fun_emp(7788) ----------------- SMITH It's work on Oracle-Pl/sql. Now how can i implemnt this function in PGSQL?
Re: BUG #2456: How to write user defined functions in Postgress sql
From
Euler Taveira de Oliveira
Date:
Vivekananda wrote: > I have good knowledge in Oracle-Pl/sql.But,now my client wants to use > PGSQL.Now i am sending function as below. > This is *not* a bug. Consider posting in the correct list pgsql-general. -- Euler Taveira de Oliveira http://www.timbira.com/