Re: [HACKERS] Repost: Get table/field-identifiers in uppercase

2001-07-17 Thread Klaus Reger
On Tuesday, 10. July 2001 11:45, you wrote: > > When a new table or field is created without quotes, it is assumed to be > > case-insensitive. Herefore I have some questions: > > > > - Is it SQL-92-conform to handle >"test"< like >test< without quotes, or > > shouldn't it be >test< forced to lower

Re: AW: [HACKERS] Repost: Get table/field-identifiers in uppercase

2001-07-10 Thread Tom Lane
Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes: > I do not think the standard states what should happen when you start mixing > quoted and unquoted identifiers for the same object. Actually, it does: 13)A and a are equiva- lent if the of the (with every

AW: [HACKERS] Repost: Get table/field-identifiers in uppercase

2001-07-10 Thread Zeugswetter Andreas SB
> When a new table or field is created without quotes, it is assumed to be > case-insensitive. Herefore I have some questions: > > - Is it SQL-92-conform to handle >"test"< like >test< without quotes, or > shouldn't it be >test< forced to lowercase? I do not understand this question. If you wan

[HACKERS] Repost: Get table/field-identifiers in uppercase

2001-07-09 Thread Klaus Reger
Hi all, because no one noticed my last question, please forgive me this repost, but I promised my boss to get an answer to this questions. Here they are: When a new table or field is created without quotes, it is assumed to be case-insensitive. Herefore I have some questions: - Is it SQL-92-c