2007/6/14, guillermo arias <[EMAIL PROTECTED]>:
could you please give me an example?.
How could i make an inner join select with temporary tables?
This function does not work:
REATE OR REPLACE FUNCTION modelo.test2(OUT xart_cod character varying, OUT
xart_descri character varying)
RETURNS SETOF record AS
$BODY$
begin
create temp table t_arti as (select art_cod,art_descri from modelo.articulos);
select $1,$2 from t_arti ;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
this is the error message:
ERROR: query has no destination for result data
SQL state: 42601
Hint: If you want to discard the results of a SELECT, use PERFORM instead.
Context: PL/pgSQL function "test2" line 4 at SQL statement
every select's output in plpgsql have to be redirected into variables.
http://www.postgresql.org/docs/8.2/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW
regards
Pavel Stehule
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
