From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Is this error expected ? |
Date: | 2022-10-19 13:57:53 |
Message-ID: | a6c3e855-92c7-f75c-637d-af66853123bd@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/19/22 01:50, Yavuz TANRIVERDİ wrote:
> |Hi,|
> |i have an |
> |
> |"ERROR: UNION types "char" and text cannot be matched CASE WHEN
> indisprimary THEN"||
> |error from |
> |https://github.com/yiisoft/yii/blob/e7c298343bf1f76186d443b62ff853d2d36e19f0/framework/db/schema/pgsql/CPgsqlSchema.php#L233|
> |I read release notes, but can't find any related change,|
> |It works for PostgreSQL 14.5 but fails with PostgreSQL ||15.0, ||a test sample below.|
> Is this error expected ?
> Thanks,
> |create table tbla ( a "char" ); |
Try CHAR(1) instead of just CHAR.
> |create table tblb ( b char(1) ); insert into tbla values ('a'); insert
> into tbla values ('b'); insert into tblb values ('c'); insert into tblb
> values ('d'); -- works with 14.5 fails on 15.0|
> |select a from tbla union all select case when true then 'p' else 'u' end
> from tblb; |
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Verite | 2022-10-19 14:29:24 | Re: How to store "blobs" efficiently for small and large sizes, with random access |
Previous Message | Tom Lane | 2022-10-19 13:34:20 | Re: byte-size of column values |