On 2009-06-02 at 12:48 +0800, W B Hacker wrote:
> BUT *NO* use of single-quotes where the element is NOT an Exim variable or
> string-literal:
>
>
> Ex: Where you have:
>
> AND user_status_type = 'active'
>
> I have:
>
> AND pg_active (no quotes)
>
> (boolean type here, so equality test need not be specified)
>
> ===
>
> AFAICS, this sort of quoting is an *SQL* requirement, not an Exim-specific one.
That's irrelevant to the question. pg_active is a column name, so
unquoted. 'active' is data, so quoted.
-Phil