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
4A9D2657020000250002A7B4@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: >> Tom Lane wrote: >>> Joseph Shraibman writes: >>>> So the type of what is in the ELSE clause determines the type of >>>> the output? >>> >>> If all the other branches are unknown literals, yes. > >> What's the best place to look to get a handle on what the benefits >> are of treating character string literals as being of unknown type? >> (Other than the obvious backward compatibility issues.) > > I think the odds of changing that are not measurably different from > zero. I figured that; I'm just trying to understand what seems to me like an odd wart on the type system. I figure I must be missing something important, so I'd kinda like to find out what that is. -Kevin
В списке pgsql-bugs по дате отправления
От: Tom Lane
Дата: