On 8/10/06, marcelo Cortez <[EMAIL PROTECTED]> wrote:
folks
i´ts is my first procedure/function
the pgadmin show 10 secs in execute it
any pointer be apreciated
use dollar quote (pg 8.0 and up):
create or replace function fs_getstring() RETURNS TEXT as
$$
[...]
$$ language plpgsql;
C
folks
i´ts is my first procedure/function
the pgadmin show 10 secs in execute it
any pointer be apreciated
CREATE OR REPLACE FUNCTION fs_getstring() RETURNS TEXT
AS '
DECLARE
DECLARE
curs1 CURSOR FOR select id_reparticion
::varchar || chr(1) || codigo_reparticion ::varch