[pgsql-es-ayuda] Type mismatch en función SQL

Fri, 24 Apr 2009 12:15:44 -0700 

Cordial saludo compañeros:

Estoy intentando definir la siguiente función y no entiendo porque me genera 
error de tipos si la tengo son SETOF RECORD ...

CREATE OR REPLACE FUNCTION columns(character varying, out character varying, 
out character varying, out character varying, out int, out int, out int, out 
character varying, out character varying, out character varying) RETURNS SETOF 
RECORD
AS
$BODY$
 SELECT  table_schema,
   column_name, 
   udt_name,
   character_maximum_length,
   numeric_precision,
   numeric_scale,
   is_nullable, 
   data_type
 FROM  information_schema.columns 
 WHERE  table_name = $1
 ORDER BY table_schema, ordinal_position
$BODY$
  LANGUAGE 'sql' VOLATILE

El error es:

ERROR:  return type mismatch in function declared to return record
DETAIL:  Final SELECT returns too few columns.
CONTEXT:  SQL function "columns"

Gracias.

Atentamente,

RAUL DUQUE
Bogotá, Colombia

Responder a