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

-- 
## List details at http://lists.exim.org/mailman/listinfo/exim-users 
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/

Reply via email to