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

2005-10-21 Thread Richard_D_Levine
"Dann Corbit" <[EMAIL PROTECTED]> wrote on 10/20/2005 04:24:26 PM: > > -Original Message- > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > > Sent: Thursday, October 20, 2005 2:12 PM > > To: Tom Lane > > Cc: Chris Travers; Dann Corbit; Greg Stark; josh@agliodbs.com; pgsql- > > [E

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

2005-10-21 Thread Richard_D_Levine
I will happily reiterate that I am the troll who started this mess by whining about how *Oracle* handles this. Tom's explanation that CHAR is has a PAD collation and VARCHAR has a NO PAD collation have restored my faith that there is goodness in the world. My whining was out of ignorance. I woul

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

2005-10-21 Thread Richard_D_Levine
Tom Lane <[EMAIL PROTECTED]> 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? > > regards, tom lane --