Re: [Pgsql-ayuda] Procedimientos almacenados

On Mon, Mar 10, 2003 at 02:02:07PM +0100, Angel Vicente Perez wrote:

> CREATE FUNCTION public.dos() RETURNS public."Patrones" AS 'SELECT * FROM
> "Patrones" AS RESULT;' LANGUAGE 'sql' VOLATILE;
>
> Pero cuando la invoco con SELECT Dos() dice :
>
> Cannot display a value of type RECORD

Welcome to psql 7.4devel, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

alvh=> create table patrones (uno int, dos text);
CREATE TABLE
alvh=> insert into patrones values (1, 'uno');
INSERT 18665 1
alvh=> insert into patrones values (2, 'dos');
INSERT 18667 1
alvh=> create function dos() returns setof patrones as 'select * from
patrones as result' language 'sql' volatile;
CREATE FUNCTION
alvh=> select * from dos() as blah(int, text);
int | text
-----+------
1 | uno
2 | dos
(2 rows)
alvh=> select * from dos() as patrones;
uno | dos
-----+-----
1 | uno
2 | dos
(2 rows)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Cada quien es cada cual y baja las escaleras como quiere" (JMSerrat)