error tryiing to insert with collate

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: error tryiing to insert with collate
Date: 2012-01-02 15:06:26
Message-ID: 20120102160626.45b5372a@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi list,

Original collation srv+clis = fr_FR.utf8

I'm trying to insert as:
INSERT INTO tst1m VALUES ( default,
'źŠÿǚŦÍÏÔJŽććżûŘäpèăîÍŢŃDµŴŻĊĜÿG' COLLATE "hu_HU.utf8",
'úĽčŏṻŗĿÁťħĵŇğŚáÛĨæħŽīhĴÝUĶďeźİīŇč' COLLATE "hu_HU.utf8" );

and get: ERROR: unsupported node type: 325

hu_HU.utf8 is installed - so is this operation impossible
and collate only reserved to select statements?

JY
--
Everything can be filed under "miscellaneous".

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thom Brown 2012-01-02 15:22:19 Re: error tryiing to insert with collate
Previous Message Craig Barnes 2012-01-01 20:07:07 Re: ERROR: invalid input syntax for integer: SQL state: 22P02