"Jean-Yves F. Barbier" <12ukwn(at)gmail(dot)com> writes:
> I'm trying to insert as:
> INSERT INTO tst1m VALUES ( default,
> 'JpDG' COLLATE "hu_HU.utf8",
> 'hUe' COLLATE "hu_HU.utf8" );
> and get: ERROR: unsupported node type: 325
Hmm, that's a bug, which I will go fix --- thanks for the report!
However, the reason that nobody noticed the bug before now is that it's
entirely useless to attach a COLLATE clause to an INSERT value.
COLLATE is only interesting when attached to an argument of an operator
or function that pays attention to collation, such as the "<" operator.
Here, your values are going to go directly into the table without any
comparisons or anything else happening to them, and once they're in
the table it'll be the table column's declared collation that controls
how they're compared.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Sergio Sinuco||Date: 2012-01-02 19:13:58|
|Subject: Re: Lock while delete a table|
|Previous:||From: Tom Lane||Date: 2012-01-02 17:07:06|
|Subject: Re: Lock while delete a table |