Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [GENERAL] 'a' == 'a '
- From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: Dann Corbit <DCorbit(at)connx(dot)com>, Richard_D_Levine(at)raytheon(dot)com, general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
- Subject: Re: [GENERAL] 'a' == 'a '
- Date: Mon, 24 Oct 2005 14:00:40 -0400 (EDT)
- Message-id: <200510241800(dot)j9OI0ei28837(at)candle(dot)pha(dot)pa(dot)us>
Is there any TODO here? --------------------------------------------------------------------------- Tom Lane wrote: > "Dann Corbit" <DCorbit(at)connx(dot)com> writes: > > I guess that additional ambiguity arises if you add additional spaces to > > the end. Many database systems solve this by trimming the characters > > from the end of the string upon storage and the returned string will not > > have any trailing blanks. > > Can you document that? ISTM that that would effectively make char(n) > and varchar(n) exactly equivalent, which is ... um ... a bit stupid. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- Bruce Momjian | http://candle.pha.pa.us pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
- References:
- Re: [GENERAL] 'a' == 'a '
- From: Tom Lane
- Re: [GENERAL] 'a' == 'a '
- Prev by Date: Re: Seeing context switch storm with 10/13 snapshot of
- Next by Date: Creating table in different database
- Previous by thread: Re: [GENERAL] 'a' == 'a '
- Next by thread: Re: [GENERAL] 'a' == 'a '
- Indexes: