Re: The folding of unquoted names to lower case in PostgreSQL
От | scott.marlowe |
---|---|
Тема | Re: The folding of unquoted names to lower case in PostgreSQL |
Дата | |
Msg-id | Pine.LNX.4.33.0303141210220.23870-100000@css120.ihs.com обсуждение исходный текст |
Ответ на | Re: The folding of unquoted names to lower case in PostgreSQL (Andrew Sullivan <andrew@libertyrms.info>) |
Ответы |
Re: The folding of unquoted names to lower case in PostgreSQL
|
Список | pgsql-general |
On Fri, 14 Mar 2003, Andrew Sullivan wrote: > On Wed, Mar 12, 2003 at 10:30:19AM -0700, scott.marlowe wrote: > > It's a hackish kluge, but not as big of one as what MapInfo would appear > > to be :-) > > To be fair, the SQL spec requires that unquoted strings be folded to > upper case, so it's really PostgreSQL's violation of the spec that is > biting here. True, very true. While mapinfo would be better had they picked one case / quoting methodology and stuck to it, the lack of a fold_to_upper setting or something similar in postgresql is a glaring flaw givin that folding to lower is against spec, not just doing something a certain way because no one bothered to define it. Any chance a patch to set a GUC for case folding would get applied?
В списке pgsql-general по дате отправления: