$variable$ will do it.
On 7/19/07, Collin Peters <[EMAIL PROTECTED]> wrote:
I am wondering how to do the following:
I have a table that has some locales in it:
CREATE TABLE i18n
(
i18n_id serial NOT NULL,
identifier character varying(50) NOT NULL,
"en_US" text NOT NULL,
"en_CA" text,
etc...
In PostgreSQL for some reason these appear as reserved words so it
puts double-quotes around them automatically. To run a select it
looks like:
SELECT identifier, "en_US"
FROM i18n
What is the correct syntax to use with iBatis in order to substitute
in a language? So something like:
SELECT i18n_id, "en_US", "#language#" FROM i18n
That syntax gives me a strange error "The column index is out of
range: 1, number of columns: 0"
Collin
