plperl syntax question
| От | stan | 
|---|---|
| Тема | plperl syntax question | 
| Дата | |
| Msg-id | 20200312223402.GA613@panix.com обсуждение исходный текст  | 
		
| Ответы | 
                	
            		Re: plperl syntax question
            		
            		 Re: plperl syntax question  | 
		
| Список | pgsql-general | 
I am trying to run a query in plperl that uses a Perl variable from the
same function.
Here is the code snippet:
my $stmt = qq("SELECT employee_key from employee where id = '$user' ;");
elog( NOTICE, "stmt = $stmt" );
my $rv3 = spi_exec_query('$stmt');
Here is the runtime output:
NOTICE:  stmt = "SELECT employee_key from employee where id = 'stan' ;"
ERROR:  syntax error at or near "$" at line 22.
As you can see, the statement seems correctly formatted, right?
What am I doing wrong here?
-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin
		
	В списке pgsql-general по дате отправления: