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

From:	Sam Mason <sam(at)samason(dot)me(dot)uk>
To:	pgsql-bugs(at)postgresql(dot)org
Subject:	Re: BUG #5028: CASE returns ELSE value always when type is "char"
Date:	2009-09-02 09:16:54
Message-ID:	20090902091654.GL5407@samason.me.uk
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2009-09-01 16:36:25 from "Joseph Shraibman" <jks(at)selectacast(dot)net>  2009-09-01 16:40:43 from Joseph Shraibman <jks(at)selectacast(dot)net>  2009-09-01 16:49:25 from Sam Mason <sam(at)samason(dot)me(dot)uk>   2009-09-01 17:00:48 from Joseph Shraibman <jks(at)selectacast(dot)net>    2009-09-01 18:17:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2009-09-01 18:30:13 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>      2009-09-01 18:42:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2009-09-01 18:49:11 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>        2009-09-01 23:48:06 from Jeff Davis <pgsql(at)j-davis(dot)com>         2009-09-02 13:57:28 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>          2009-09-02 14:11:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2009-09-02 14:24:53 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>          2009-09-02 14:44:36 from Jeff Davis <pgsql(at)j-davis(dot)com>           2009-09-02 14:50:05 from Greg Stark <gsstark(at)mit(dot)edu>            2009-09-02 15:55:31 from Sam Mason <sam(at)samason(dot)me(dot)uk>             2009-09-02 16:36:00 from Robert Haas <robertmhaas(at)gmail(dot)com>              2009-09-02 16:57:19 from Sam Mason <sam(at)samason(dot)me(dot)uk>             2009-09-02 17:19:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2009-09-02 17:44:21 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>               2009-09-02 17:58:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2009-09-02 18:09:20 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                 2009-09-02 18:21:18 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                  2009-09-02 18:41:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2009-09-02 18:55:28 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                    2009-09-02 19:07:48 from Sam Mason <sam(at)samason(dot)me(dot)uk>              2009-09-02 17:45:34 from Sam Mason <sam(at)samason(dot)me(dot)uk>               2009-09-02 17:54:03 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                2009-09-02 18:18:53 from Sam Mason <sam(at)samason(dot)me(dot)uk>                 2009-09-02 18:27:35 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                  2009-09-02 18:37:20 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                   2009-09-02 19:08:19 from Sam Mason <sam(at)samason(dot)me(dot)uk>                    2009-09-02 19:41:32 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                     2009-09-02 20:04:26 from Sam Mason <sam(at)samason(dot)me(dot)uk>                     2009-09-02 20:07:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                      2009-09-02 20:22:39 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                       2009-09-02 21:01:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2009-09-02 21:26:50 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                         2009-09-02 21:44:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2009-09-02 21:53:35 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                      2009-09-02 20:46:43 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                  2009-09-02 18:38:47 from Sam Mason <sam(at)samason(dot)me(dot)uk>                2009-09-02 18:49:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2009-09-02 19:34:51 from Sam Mason <sam(at)samason(dot)me(dot)uk>                 2009-09-02 19:59:54 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                  2009-09-02 20:17:22 from Sam Mason <sam(at)samason(dot)me(dot)uk>                   2009-09-02 20:33:58 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                   2009-09-02 20:55:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                    2009-09-02 21:27:30 from Greg Stark <gsstark(at)mit(dot)edu>                 2009-09-03 01:21:55 from Robert Haas <robertmhaas(at)gmail(dot)com>           2009-09-02 14:52:10 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>   2009-09-02 09:16:54 from Sam Mason <sam(at)samason(dot)me(dot)uk> 📎    2009-09-02 14:39:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2009-09-04 15:15:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2009-09-04 15:50:25 from Robert Haas <robertmhaas(at)gmail(dot)com>     2009-09-04 15:59:48 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>      2009-09-04 16:37:01 from Robert Haas <robertmhaas(at)gmail(dot)com>      2009-09-04 17:03:29 from Sam Mason <sam(at)samason(dot)me(dot)uk>       2009-09-04 17:26:19 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>        2009-09-04 17:59:34 from Sam Mason <sam(at)samason(dot)me(dot)uk>         2009-09-04 19:01:07 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>          2009-09-04 19:19:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2009-09-04 19:32:17 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>          2009-09-04 19:37:07 from Sam Mason <sam(at)samason(dot)me(dot)uk>     2009-09-04 17:53:53 from Jeff Davis <pgsql(at)j-davis(dot)com>
Lists:	pgsql-bugs

Attachment	Content-Type	Size
pg-8.4-char.patch	text/x-diff	451 bytes

In response to

• Re: BUG #5028: CASE returns ELSE value always when type is "char" at 2009-09-01 16:49:25 from Sam Mason

Responses

• Re: BUG #5028: CASE returns ELSE value always when type is "char" at 2009-09-02 14:39:04 from Tom Lane
• Re: BUG #5028: CASE returns ELSE value always when type is "char" at 2009-09-04 15:15:21 from Tom Lane

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	Heikki Linnakangas	2009-09-02 11:00:14	Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4.
Previous Message	Magnus Hagander	2009-09-02 07:57:01	Re: lost statistics; analyze needs to execute twice