[GENERAL] Syntax error at or near "$1"

[Ryan Booz]

I'm working with different functions and following an example of iterating
through rows from a returned query.  It's not a complicated function, but I
can't get past this parse error.  I've tried numerous things and searched
for some help.  I can't find any reason for the error below:

ERROR:  syntax error at or near "$1" at character 30
CONTEXT:  PL/pgSQL function "list_devices" line 6 at for over select rows

Any help would be greatly appreciated!

Thanks,
Ryan

CREATE FUNCTION list_devices(macaddr) RETURNS text AS '
DECLARE
    macAddress ALIAS FOR $1;
    rowval record;
    devices text;
BEGIN
    devices := '' '';
    FOR rowval IN SELECT device_type_id FROM devices WHERE mac_address =
macAddress LOOP
        devices := devices || ''\r'';
    END LOOP;
RETURN devices;
END;
' LANGUAGE 'plpgsql';


------------
Ryan J. Booz
Research Programmer
Penn State University
Information Technology Services
TLT/CLC
[EMAIL PROTECTED]



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly