public inbox for [email protected]  

help / color / mirror / Atom feed

From: gmail Vladimir Koković <[email protected]>
To: David G. Johnston <[email protected]>
Cc: pgsql-novice <[email protected]>
Cc: Ken Benson <[email protected]>
Subject: Re: chr(3) and 3::text
Date: Sat, 28 Mar 2020 16:39:51 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKFQuwar77hZNwgnaCpMjOt6vAvHWnuqo-NsAgOOcqBFtzFPtg@mail.gmail.com>
References: <[email protected]>
	<CAKFQuwaMQCb4QNA1+q8-3ZBgTMdoWFnvvSfUP4z6L5E7uCQOQw@mail.gmail.com>
	<[email protected]>
	<CAKFQuwar77hZNwgnaCpMjOt6vAvHWnuqo-NsAgOOcqBFtzFPtg@mail.gmail.com>

On 28.3.20. 16:25, David G. Johnston wrote:
>
> The convention here is to bottom or inline post, trimming unnecessary 
> content.
>
> Its that way because :: is defined to make it that way.
>
> 3 has a type of integer
> '3' has a type of text
> ::<type> is the PostgreSQL type casting operator that casts its left 
> to to <type> (see the documentation I linked to)
>
> So:
>
> integer::text == text
>
> cast(integer as text) == text
>
> is the SQL Standard equivalent expression
>
> David J.
>
integer::text == text, but which character 0x03 or 0x33 ?

Text should contain characters.

Characters is from character set.

Character 0x03 is valid in ASCII and UTF-8 character sets.

view thread (12+ messages)  latest in thread

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]
  Subject: Re: chr(3) and 3::text
  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