Re: [exim] single quote question / problem

Kezdőlap
Üzenet törlése
Válasz az üzenetre
Szerző: Phil Pennock
Dátum:  
Címzett: W B Hacker
CC: exim users
Tárgy: Re: [exim] single quote question / problem
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