Re: [GENERAL] my first procedure

2006-08-10 Thread Merlin Moncure
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

[GENERAL] my first procedure

2006-08-10 Thread marcelo Cortez
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