Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

ERROR: RETURN NEXT must specify a record or row variable in function returning tuple



DECLARE v_row record;
BEGIN
select 1, row( 1,2) as result into v_scalar, v_row;
return next v_row.result
END;
This code cause "ERROR: RETURN NEXT must specify a record or row variable in function returning tuple"
BUG? TODO?
 
 
DECLARE v_row record;
DECLARE v_result record;

BEGIN
select 1, row( 1,2) as result into v_scalar, v_row;
v_result= v_row.result;
return next v_result;
END;
This workaround work fine


Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group