Re: [HACKERS] 'a' == 'a '

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard_D_Levine(at)raytheon(dot)com
Cc: Chris Travers <chris(at)travelamericas(dot)com>, Dann Corbit <DCorbit(at)connx(dot)com>, Greg Stark <gsstark(at)mit(dot)edu>, josh(at)agliodbs(dot)com, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, Terry Fielder <terry(at)ashtonwoodshomes(dot)com>, Tino Wildenhain <tino(at)wildenhain(dot)de>
Subject: Re: [HACKERS] 'a' == 'a '
Date: 2005-10-20 21:38:41
Message-ID: 14310.1129844321@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Richard_D_Levine(at)raytheon(dot)com writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote on 10/20/2005 03:11:23 PM:
>> The hard part would be in figuring out how
>> the output routine could know how many spaces to add back.

> The length is in the metadata for the column, or am I being dense?

The output routine hasn't got access to that metadata. In general,
in fact, a random Datum can't be linked to any column since it may have
been generated on-the-fly.

It'd be easy if we stuck the column width into the stored representation
of bpchar, but this would defeat one of the purposes, ie, to make the
stored representations of text and bpchar alike.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2005-10-20 21:46:08 Re: Unique index with Null value in one field
Previous Message Simon Riggs 2005-10-20 21:32:09 Re: Checking Multiplicity Constraints and Retrieving

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard_D_Levine 2005-10-20 21:49:03 Re: [GENERAL] 'a' == 'a '
Previous Message Tom Lane 2005-10-20 21:35:31 Re: Seeing context switch storm with 10/13 snapshot of