Re: inner join problem with temporary tables

2007/6/14, guillermo arias <guillermoariast@linuxwaves.com>:
> 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