[julia-users] Variable values into a table (postgres)

[Douglas Teixeira Goncalves]

Hi guys,

I've tried to insert some values into a table (postgres)

I was successful when I put:

   query("INSERT INTO sum_access(contact_id,sum_reg) VALUES ('1','10')")


But, when I replace the integer values for variables like:


   value = 10

   sum = 15


   query("INSERT INTO sum_access(contact_id,sum_reg) VALUES ('value','sum')")


it doesn't work. The message error is: [ODBC] 22P02: ERROR: invalid input 
syntax for integer: "value";

                                       Error while executing the query


If anyone could help me it would be great!


Thank you,


Douglas