Re: trailing space in column name

[Kristian Nielsen]

Joerg Bruehe <Joerg.Bruehe@stripped> writes:

> Kristian Nielsen wrote:
>> In any case, I think this should be considered a bug (if a documented one
>> :-). If I can create a table/column ` t` or `t t`, there is no reason I should
>> not be able to create also `t `.
>
> IMHO, there is no real need to have blanks in table names or any other
> identifiers (and the same holds for file names, BTW).

Very true.

> I don't have the reference handy, so I can't quote verbatim, but I do
> remember that the X/Open standard for SQL specifies something like
>   "All character strings are comparable.
>    If character strings are of different length, then the shorter one is
>    conceptually padded with blanks at the end before comparison."
>
> This exactly means that "X" == "X ", for any "X".

I see, I did not know that, thanks for the info!

 - Kristian.