Postgres Pro
Downloads
Home   >   mailing lists

Weird issue with truncation of values in array with some tables - Mailing list pgsql-sql

From Mike Martin
Subject Weird issue with truncation of values in array with some tables
Date
Msg-id CAOwYNKYfKPfAL4rgP0AO_w0Mn7h8yiXd_Qi9swPdAc4CAUXeAQ@mail.gmail.com
Whole thread Raw
Responses Re: Weird issue with truncation of values in array with some tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Weird issue with truncation of values in array with some tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Mike Martin
Date:
Subject: Re: Use multidimensional array as VALUES clause in insert
Next
From: "David G. Johnston"
Date:
Subject: Re: Weird issue with truncation of values in array with some tables