Dave Gudeman wrote:
On Mon, Oct 20, 2008 at 2:28 AM, Heikki Linnakangas <
[EMAIL PROTECTED]> wrote:
Tom Lane wrote:
Another objection to this design is that it's completely unclear that
functions from text to text should necessarily yield the same collation
that went into them, but if you treat
On Mon, Oct 20, 2008 at 2:28 AM, Heikki Linnakangas <
[EMAIL PROTECTED]> wrote:
> Tom Lane wrote:
>
>> Another objection to this design is that it's completely unclear that
>> functions from text to text should necessarily yield the same collation
>> that went into them, but if you treat collation
Tom Lane wrote:
Another objection to this design is that it's completely unclear that
functions from text to text should necessarily yield the same collation
that went into them, but if you treat collation as a hard-wired part of
the expression syntax tree you aren't going to be able to do anythi
On Sat, Oct 18, 2008 at 11:28:41AM -0400, Tom Lane wrote:
> It's fairly irritating to think that a string-specific option is going
> to become part of the fundamental type system --- it makes no sense to
> distinguish different collations for numeric for instance (and in fact
> I would want to see
Tom Lane <[EMAIL PROTECTED]> writes:
> It's fairly irritating to think that a string-specific option is going
> to become part of the fundamental type system --- it makes no sense to
> distinguish different collations for numeric for instance
Actually I thought of that generality as an advantage
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> It's quite straightforward. Every expression has a collation, the COLLATE
> keyword just overrides it. And the collation is a parameter of the
> operators/functions that want to use it. Implementation is also
> straightforward: add expr :: expr C
On Sat, Oct 18, 2008 at 07:41:12AM +0100, Gregory Stark wrote:
> The ANSI standard syntax where the COLLATION keyword can follow just about any
> string value in an expression and then bubbles up the expression until an
> operation needs to pick a collation seemed very weird to us. Hooking that int
Radek, Zdenek, and Heikki had an extended discussion here at PGDay.it on
collation support. I was volunteered to be the note-taker (!). Here is the
plan we came up with:
Firstly, the ANSI standard makes collations into schema-qualified names which
pretty much forces us to have the collation catal
