From: Markus Schaber <schabi@logix-tt.com>
To: pgsql-sql@postgresql.org
Subject: Re: have you feel anything when you read this ?
Date: Thu, 06 Apr 2006 14:39:33 +0200
Message-ID: <44350C05.5020401@logix-tt.com> (raw)
In-Reply-To: <20060406041008.M82943@megazone.bigpanda.com>
References: <Pine.LNX.4.44.0603201522410.22894-100000@matrix.gatewaynet.com>
<441EA0A7.8030601@bankir.ru>
<200603201415.30719.peter_e@gmx.net>
<442CC95C.1030700@bankir.ru>
<20060331084503.W64402@megazone.bigpanda.com>
<44324AB6.2060104@bankir.ru>
<20060404071118.C19036@megazone.bigpanda.com>
<4433650E.1020508@bankir.ru>
<20060405071322.Y58168@megazone.bigpanda.com>
<4434A207.6010600@bankir.ru>
<20060405224337.Y83930@megazone.bigpanda.com>
<4434C0A9.6000001@bankir.ru>
<20060406041008.M82943@megazone.bigpanda.com>
Hi, Stephan & Eugene,
Stephan Szabo wrote:
> This is already false AFAICS. Leading or trailing spaces on a string
> containing integer get trimmed during the input for example, the string
> format of date comes back in a particular but other input formats are
> supported. I don't think the above equality is valid for textual
> representation.
It is even true that the server-internal storage format can be distinct
from both the textual and binary representation (aka canonical rep.).
This is e. G. how PostGIS handles their geometries. PostGIS geometries
have even more representations, available via conversion functions.
And for some unicode strings, it even happens that their textual
representation is different depending on the client encoding.
>>I expect a value of BYTEA to be unchaged too.
> I think (as above) that your perception of the problem isn't correct.
I agree. The value of the BYTEA is unchanged, it is just a different
representation of the BYTEA that allows handling its contents as text,
in non-binary safe environments.
Imagine having the text representation as simply HEXing the BYTEA
contents - it still is an unchanged value.
>>why not to define your own unique more_sofisticated representation ?
>>(as for bytea is defined.)
> AFAICS, there is one, the binary format for integer.
Exactly.
AFAICS, all built-in data types have both a text and binary
representation, as well as most extension types.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
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: pgsql-sql@postgresql.org
Cc: schabi@logix-tt.com
Subject: Re: have you feel anything when you read this ?
In-Reply-To: <44350C05.5020401@logix-tt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox