Tom Lane wrote:
> Dennis Bjorklund <db@zigo.dhs.org> writes:
> > My next question is about lexing. The spec says that one can use
> > strings of different charsets in the queries, like:
> > ... WHERE field1 = _latin1'FooBar' and field2 = _utf8'Åäö'
> > I can see that the lexer either needs to be taught about all the
> > different charsets or this is not going to work very well.
>
> Yeah. I'm not sure that we're ever going to support that part of the
> spec; doing so would break too many useful things without adding very
> much useful functionality.
Like what? I think it could be fairly useful. We would have to
restrict ourselves to character sets that are supersets of ASCII, but
there are boatloads of reasons to do that besides this issue.