Broken PL/PgSQL for 7.0 beta 3?
The following code works under 6.5 and doesn't work in 7.0 beta 3. Comments?
------------------snip---------------------------------------
create table paths ( pathnum serial, pathname text );
CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
'/opt/brupro/pgsql/lib/plpgsql.so' LANGUAGE 'C';
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
HANDLER plpgsql_call_handler
LANCOMPILER 'PL/pgSQL';
/**********************************************************
* This function makes handling paths MUCH faster on inserts:
**********************************************************/
CREATE FUNCTION get_path (text) RETURNS integer AS '
DECLARE
retval integer;
BEGIN
select pathnum into retval from paths where pathname = $1 ;
if not found then
insert into paths ( pathname )values ( $1 ) ;
select pathnum into retval from paths where pathname = $1 ;
end if ;
return retval ;
END;
' LANGUAGE 'plpgsql';
select get_path('/etc');
--------------end snip-------------------------------
--
Eric Lee Green eric@estinc.com
Software Engineer Visit our Web page:
Enhanced Software Technologies, Inc. http://www.estinc.com/
(602) 470-1115 voice (602) 470-1116 fax
The following code works under 6.5 and doesn't work in 7.0 beta 3. Comments?
Symptoms?
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
Eric Lee Green <pgsql-hackers@estinc.com> writes:
The following code works under 6.5 and doesn't work in 7.0 beta 3. Comments?
Please define "doesn't work". I get (starting with a virgin paths table)
tpc=# select get_path('/etc');
get_path
----------
1
(1 row)
tpc=# select get_path('/etc');
get_path
----------
1
(1 row)
tpc=# select get_path('/etcz');
get_path
----------
2
(1 row)
tpc=# select get_path('/etcz');
get_path
----------
2
(1 row)
tpc=# select get_path('/etc');
get_path
----------
1
(1 row)
which seems to be the intended behavior.
It might help to know what platform/compiler you are using, too.
regards, tom lane