dow question - Mailing list pgsql-sql

Hi All,

I am working on a query which in part is

CASE   WHEN extract(dow from tbl_detail.ship_by_date) = 0      THEN 'Sunday ' || tbl_detail.ship_by_date::text   WHEN
extract(dowfrom tbl_detail.ship_by_date) = 1      THEN 'Monday ' || tbl_detail.ship_by_date::text   WHEN extract(dow
fromtbl_detail.ship_by_date) = 2      THEN 'Tuesday ' || tbl_detail.ship_by_date::text   WHEN extract(dow from
tbl_detail.ship_by_date)= 3      THEN 'Wednesday ' || tbl_detail.ship_by_date::text   WHEN extract(dow from
tbl_detail.ship_by_date)= 4      THEN 'Thursday ' || tbl_detail.ship_by_date::text   WHEN extract(dow from
tbl_detail.ship_by_date)= 5      THEN 'Friday ' || tbl_detail.ship_by_date::text   WHEN extract(dow from
tbl_detail.ship_by_date)= 6      THEN 'Saturday ' || tbl_detail.ship_by_date::text
 
END AS sort_by_string

Is there a better way to do this?  The CASE seems inefficient and wordy 
but perhaps not.

I was hoping for

day_name(tbl_detail.ship_by_date) || tbl_detail.ship_by_date::text AS 
sort_by_string

but AFAIK day_name(date) or something like it is merely my fantasy. ;-)

-- 
Kind Regards,
Keith