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
Дата: