Re: %d and %s in mysql queries?

2010-01-30 Thread Wietse Venema
Jeff Weinberger:
 I am using mysql (quite successfully in most cases) to do lookups for
 a variety of reasons in postfix.
 
 Recently, I had some issues with a domain lookup and in the testing
 tried varying my MySQL query between using %d and %s as the lookup
 key.
 
 The documentation is clear on this when the query is for an address.

The %d is defined when a key or result is an address:

  %d When the input key is an address of the form u...@domain,

  %d When  a  result attribute value is an address of the form
 u...@domain

Therefore, %d is not defined for non-address forms.

Wieste


Re: %d and %s in mysql queries?

2010-01-30 Thread Jeff Weinberger
On Sat, Jan 30, 2010 at 4:41 PM, Wietse Venema wie...@porcupine.org wrote:
 Jeff Weinberger:
 I am using mysql (quite successfully in most cases) to do lookups for
 a variety of reasons in postfix.

 Recently, I had some issues with a domain lookup and in the testing
 tried varying my MySQL query between using %d and %s as the lookup
 key.

 The documentation is clear on this when the query is for an address.

 The %d is defined when a key or result is an address:

              %d     When the input key is an address of the form u...@domain,

              %d     When  a  result attribute value is an address of the form
                     u...@domain

 Therefore, %d is not defined for non-address forms.

        Wieste


Thank you!

So my use of %d in the case of relay_domains lookup was just
incorrect. I understand this now - thanks.