Michal Hlavac <[EMAIL PROTECTED]> writes:
> groups[] := tmpi;
> returns error: syntax error at or near "["
This is supported in PG 7.4 (although you do need to provide a subscript
expression ...)
regards, tom lane
---(end of broadcast)
DECLARE
groups integer[];
tmp RECORD;
tmpi integer;
BEGIN
FOR tmp IN SELECT i_group_id FROM l_group_to_user WHERE i_user_id =
$1 LOOP
SELECT i_group_id INTO tmpi FROM s_group WHERE i_group_id =
tmp.i_group_id;
groups[] := tmpi;
RETURN NEXT tmp.i_group_id;
END LOOP;
RETURN
