Re: BUG #5028: CASE returns ELSE value always when type is"char"

Поиск
Список
Период
Сортировка
Искать
От
Kevin Grittner
Тема
Re: BUG #5028: CASE returns ELSE value always when type is"char"
Дата
Msg-id
4A9E9363020000250002A968@gw.wicourts.gov
Ответ на
Список
Дерево обсуждения
BUG #5028: CASE returns ELSE value always when type is "char" "Joseph Shraibman" <jks@selectacast.net>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Jeff Davis <pgsql@j-davis.com>
Re: BUG #5028: CASE returns ELSE value always when type is "char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is "char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is "char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is "char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Robert Haas <robertmhaas@gmail.com>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Robert Haas <robertmhaas@gmail.com>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Joseph Shraibman <jks@selectacast.net>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is "char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is "char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Jeff Davis <pgsql@j-davis.com>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Jeff Davis <pgsql@j-davis.com>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Greg Stark <gsstark@mit.edu>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Greg Stark <gsstark@mit.edu>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Robert Haas <robertmhaas@gmail.com>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Robert Haas <robertmhaas@gmail.com>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason <sam@samason.me.uk>
Re: BUG #5028: CASE returns ELSE value always when typeis"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5028: CASE returns ELSE value always when type is"char" "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: BUG #5028: CASE returns ELSE value always when type is "char" Joseph Shraibman <jks@selectacast.net>
Tom Lane  wrote:
> "Kevin Grittner"  writes:
 
>> go with the suggestion of having a character string literal type,
>> and change the semantics such that if there is a valid
>> interpretation of the statement with the character string literal
>> taken as text, it should be used; if not, resolve by current
>> "unknown" rules.
> 
> There is already a weak preference for resolving unknown as text in
> the presence of multiple alternatives.  So I'm not sure that you're
> suggesting anything different from what happens now.
 
It is certainly different for the example I gave up-thread involving
"char".  Perhaps that is a very unique and isolated situation.
 
-Kevin
В списке pgsql-bugs по дате отправления
От: Kevin Grittner
Дата:
От: Tom Lane
Дата:
FAQ