ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: Usage of reserved words using PostgreSQL
Date Fri, 20 Jul 2007 02:49:01 GMT
$variable$ will do it.

On 7/19/07, Collin Peters <cadiolis@gmail.com> 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
>

Mime
View raw message