Re: Case Insensitive Data Type

>Assuming you did have all that, I think a query like
>
>         select * from foo where email = 'Joe Blow <joe@blow.com>'
>
>would indeed work the way you want --- the initially untyped string
>literal would eventually get coerced to your datatype, and then your
>input conversion routine could do the right things to it.  But it'll
>likely be easier to make it happen on the client side ;-)

Since he is using EJB, he is probably stripping out everything already
except the core SMTP e-mail address (probably using
javax.mail.internet.InternetAddress's parser).

Not that this is in the least bit relevant to PG so I'll just shut up now. :)

Cheers,

Doug