Re: The folding of unquoted names to lower case in

Поиск
Список
Период
Сортировка
От Lincoln Yeoh
Тема Re: The folding of unquoted names to lower case in
Дата
Msg-id 5.1.0.14.1.20030315140539.02822ec0@mbox.jaring.my
обсуждение исходный текст
Ответ на 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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
At 01:50 PM 3/14/03 -0500, 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.

Yah, but following the SQL spec in that would violate my eyes :).

Would a compile time setting be easier to do than a GUC? Everything
unquoted folds up, and the system tables when doing initdb are all upper
case (UGH!).

That'll be fun to regression test tho ;).

Link.


В списке pgsql-general по дате отправления:

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Re: type-casting and LIKE queries
Следующее
От: "Arunachalam Jaisankar"
Дата:
Сообщение: How to change default date format?