i have a function of a user defined type it returns a record of values but
just a row.
select * from rec_f_consultar_alumno(a.ent_codigo, a.alu_codigo)
what i want to do now is a select in wich i can do a seq scan or an index
scan of a table and
pass the values i retrieve into the function. the select have to retrieve
the result of the function.
i can do that whit a function with setof but i want to know if it is
possible to do it with a select
Add photos to your messages with MSN 8. Get 2 months FREE*.
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2004-06-01 02:05:11|
|Subject: Re: insert or update violates foreign key constraint.why? |
|Previous:||From: sad||Date: 2004-05-31 07:52:42|
|Subject: type regclass casting|