[Pgsql-ayuda] Crear funcion.

[Alvaro Herrera]

On Thu, May 29, 2003 at 06:44:33PM -0400, Leonardo Boet Sánchez wrote:
> Buenas tardes, soy nuevo en el mundo de postgres.
> quisiera crear una funcion que me retorne un conjunto de registro. lo trato de hacer con el psql 

test=> create table autor (id serial primary key, nombre text);
NOTICE:  CREATE TABLE will create implicit sequence 'autor_id_seq' for SERIAL column 'autor.id'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'autor_pkey' for table 'autor'
CREATE TABLE
test=> create table libro (id serial primary key, id_autor int4 references autor,
titulo text);
NOTICE:  CREATE TABLE will create implicit sequence 'libro_id_seq' for SERIAL column 'libro.id'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'libro_pkey' for table 'libro'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
CREATE TABLE
test=> create function muestra_libros () returns setof record as 'select
nombre, titulo from autor join libro on (id_autor=autor.id)' language sql;
CREATE FUNCTION
test=> select * from muestra_libros() as foo(autor text, titulo text);
     autor     |              titulo
---------------+----------------------------------
 Don Knuth     | The Art of Computing Programming
 J.R.R.Tolkien | The Hobbit
 J.R.R.Tolkien | The Lord of the Rings
(3 rows)

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Some men are heterosexual, and some are bisexual, and some
men don't think about sex at all... they become lawyers" (Woody Allen)