[gnome-db] String escaping question



Hi!

I tried to execute the following query on postgresql:

ALTER GROUP "glom_developers" ADD USER ##name::gchararray

the holder name was defined as "jhs".

The result was the following error:
Syntax error at »'jhs'«
LINE 1:  ALTER GROUP "glom_developer" ADD USER 'jhs'

The same query works as
ALTER GROUP "glom_developers" ADD USER "jhs" (note the difference
between ' and ".

Is there anything wrong with the query. Can I specify different
behaviour for the holder?

Thanks,
Johannes

Attachment: signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]