Michael Glaesemann wrote:
On Dec 8, 2005, at 11:03 , Keith Worthington wrote:
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_nam
On Dec 8, 2005, at 11:03 , Keith Worthington wrote:
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 i
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(dow from tbl_detail.ship_by_date) = 1
THEN 'Monday ' || tbl_detail.ship_by_date::text
WHEN extract(dow from t
