- Original Message -
From: Tatsuo Ishii <[EMAIL PROTECTED]>
Sent: Saturday, August 18, 2001 10:02 PM
> ALT -> IBM866
Just a quick comment: ALT is not necessarily IBM866.
It can be any US-ASCII or 26-character-alphabet Latin set, for example
IBM819 or ISO8859-1. Is actually quite d
> Hi,
>
> attached is patch with:
>
> - new encoding names stuff with better performance (binary search
> intead for() and prevent some needless searching)
>
> - possible is use synonyms for encoding (an example ISO-8859-1,
> Latin1, l1)
>
> - implemented is Peter's idea about "encoding
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Now, if you look at the code that does the LIKE pattern matching you'll
> see that it does not use any locale features, it simply compares
> characters for equality based on their character codes, accounting for the
> wildcards. Consequentially, this
Hiroshi Inoue writes:
> Please look at my first question.
>This depends on the assumption that '=' is equivalent in
>any locale. Is it guaranteed ?
>For example, ( 'a' = 'A' ) isn't allowed in any locale ?.
>
> And your answer was
>The whole point here is not to rely on '='.
>
> C
> -Original Message-
> From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
>
> Hiroshi Inoue writes:
>
> > Isn't 'a' LIKE 'A' if 'a' = 'A' ?
>
> Yes. But 'a' <> 'A'.
Please look at my first question.
This depends on the assumption that '=' is equivalent in
any locale. Is it guaran
Just a suggestion, how much work would it be to accept multiple parameters on
aggregate functions?
For instance:
select fubar(field1, field2) from table one group by field1;
The reason I think that this is useful is that for some statistical operations,
often times there is extra "per record"
Perhaps this question would be better directed to -general?
The documentation for PostgreSQL is suprisingly good as well but I assume
you've read that and are still confused :)
AZ
"Peter Moscatt" <[EMAIL PROTECTED]> wrote in message
jaof7.127918$[EMAIL PROTECTED]">news:jaof7.127918$[EMAIL PROTE
Hiroshi Inoue writes:
> Isn't 'a' LIKE 'A' if 'a' = 'A' ?
Yes. But 'a' <> 'A'.
> LIKE seems to use the collating sequence.
No. The collating sequence defines the order of all possible strings.
LIKE doesn't order anything.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net
> -Original Message-
> From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
>
> Hiroshi Inoue writes:
>
> > > An operator class text_binary_ops that does memcmp()-based
> comparison of
> > > text data. The operators are named $<$ etc. for lack of a
> better idea.
> > > That lack is further i
Hiroshi Inoue writes:
> > An operator class text_binary_ops that does memcmp()-based comparison of
> > text data. The operators are named $<$ etc. for lack of a better idea.
> > That lack is further illustrated by the idea to name them "binary-<" etc.,
> > which wouldn't get through the parser,
10 matches
Mail list logo
