ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Collin Peters" <cadio...@gmail.com>
Subject Usage of reserved words using PostgreSQL
Date Fri, 20 Jul 2007 02:24:37 GMT
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

Mime
View raw message