Weird issue with truncation of values in array with some tables

From: Mike Martin <redtux1(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Weird issue with truncation of values in array with some tables
Date: 2020-08-16 13:48:16
Message-ID: CAOwYNKYfKPfAL4rgP0AO_w0Mn7h8yiXd_Qi9swPdAc4CAUXeAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi
I have come across a weird issue with truncation of text in an array (in
this case using pg_indexes view)

This query truncates the second array element at 63 characters
SELECT ARRAY[indexname,indexdef] FROM pg_indexes

However reversing the order doesn't truncate

SELECT ARRAY[indexdef,indexname] FROM pg_indexes

Anyone know why this behaviour occurs?

thanks

Mike

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2020-08-16 15:13:20 Re: Weird issue with truncation of values in array with some tables
Previous Message Mike Martin 2020-08-11 20:59:12 Re: Use multidimensional array as VALUES clause in insert