Re: Syntax error at or near "$1" - Mailing list pgsql-general

Ryan Booz <rxb19@psu.edu> writes:
> I can't find any reason for the error below:

CVS tip gives a slightly more complete error message:

regression=# select list_devices('123456789012');
ERROR:  syntax error at or near "$1" at character 30
QUERY:  SELECT  device_type_id FROM  $1  WHERE mac_address =  $2
CONTEXT:  PL/pgSQL function "list_devices" line 7 at for over select rows
LINE 1: SELECT  device_type_id FROM  $1  WHERE mac_address =  $2
                                     ^
regression=#

This might or might not help you figure out the problem: you used
"devices" as both a plpgsql variable name and a referenced table.
Pick another name for the variable.

            regards, tom lane