function query error: column does not exist

From: giozh <giozh(at)yahoo(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: function query error: column does not exist
Date: 2013-07-11 09:01:05
Message-ID: 1373533265226-5763460.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i've a function takes as argument some values of few types, and make some
INSERT operation using that values.
I've occour an error while calling that function, the error is on a varchar
variable.

this is the insert code:

>EXECUTE 'INSERT INTO table VALUES('||value1||','[...]','||value_char||')';

and the error is on value_char. pg told me that "column does not exist".
Why?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/function-query-error-column-does-not-exist-tp5763460.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jayadevan M 2013-07-11 09:19:28 Re: pg recovery
Previous Message Giuseppe Broccolo 2013-07-11 08:55:50 Re: pg recovery