dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

2011/11/15 Lars Helge Øverland <larshelge@xxxxxxxxx>:
> Hi Jason,
>
> you are correct. For some very weird reason we had chosen to make an
> exception for postgres and escape single-quote with a backslash, while
> doubling it ( '' ) is the standard and preferred way in sql. Hence it
> did not only affect resource tables but all places we do direct sql. I
> have fixed this now in trunk. Would be grateful if you could give it a
> try now and see if it works properly. Thanks for reporting.

Pretty sure this should work.  FWIW its also what I do on mydatamart
as sqlite also uses the tick-tick encoding for a tick.

>
> Lars
>