Re: [Gnumed-devel] When table column in postgres has been named 'group'

[Busser, Jim]

On 2011-11-13, at 12:29 AM, Karsten Hilbert wrote:

> On Sun, Nov 13, 2011 at 02:31:32AM +0000, Jim Busser wrote:
> 
>> but if I try to include the column named 'group' I get
>> 
>>      gnumed_v16=> select group from cfg.v_cfg_options ;
>>      ERROR: syntax error at or near "group"
>>      LINE 1: select group from cfg.v_cfg_options ;
> 
> Either quote or qualify it.

Ah! I had tried but single quoting

        'group'

when what is needed is

        "group"

!

-- Jim