public inbox for [email protected]
help / color / mirror / Atom feedFrom: Rob Sargent <[email protected]>
To: Igor Korot <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: David G. Johnston <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: How to properly use TRIM()?
Date: Sat, 7 Mar 2026 12:19:52 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+FnnTwxSeLhR8zNZsoR2SAXYVf9Db+zi3+SpPqdBe==m3X-AQ@mail.gmail.com>
References: <CA+FnnTwxSeLhR8zNZsoR2SAXYVf9Db+zi3+SpPqdBe==m3X-AQ@mail.gmail.com>
--Apple-Mail-7605932D-B951-446A-AA0B-EFEBB6F1B4D3
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html class=3D"apple-mail-supports-explicit-dark-mode"><head><meta http-equi=
v=3D"content-type" content=3D"text/html; charset=3Dutf-8"></head><body dir=3D=
"auto"><div dir=3D"ltr"></div><div dir=3D"ltr"><br></div><blockquote type=3D=
"cite"><div dir=3D"ltr"><div><div class=3D"gmail_quote gmail_quote_container=
"><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1=
px #ccc solid;padding-left:1ex">reloptions text[]</blockquote><div dir=3D"au=
to"><br></div><div dir=3D"auto">Then why it=E2=80=99s not showing {} as in t=
he =E2=80=9Cincluded=E2=80=9D columns?</div><div dir=3D"auto"><br></div><div=
dir=3D"auto">Or it=E2=80=99s an ARRAY() implementation?</div><div dir=3D"au=
to"><br></div><div dir=3D"auto">Thank you.</div><div dir=3D"auto"><br></div>=
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px=
#ccc solid;padding-left:1ex" dir=3D"auto"><br></blockquote></div></div></di=
v></blockquote><div><br></div>One is an empty array, the other is null. Thos=
e are not the same thing. <div><br><blockquote type=3D"cite"><div dir=3D=
"ltr"><div><div class=3D"gmail_quote gmail_quote_container"><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex" dir=3D"auto">
<br>
<br>
> Included is one, storage is not.<br>
> <br>
> Thank you.<br>
> <br>
>><br>
>> Given that error message, an array of text is the correct type.<br>=
>><br>
>> Array[]::text[]<br>
>><br>
>> David J.<br>
>><br>
> <br>
> <br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:[email protected]" target=3D"_blank">adrian.klaver=
@aklaver.com</a><br>
</blockquote></div></div>
</div></blockquote></div></body></html>=
--Apple-Mail-7605932D-B951-446A-AA0B-EFEBB6F1B4D3--
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: How to properly use TRIM()?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox