Re: help with query: advanced ORDER BY...

From: <me(at)alternize(dot)com>
To: "Michael Glaesemann" <grzm(at)myrealbox(dot)com>
Cc: "Michael Fuhr" <mike(at)fuhr(dot)org>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: help with query: advanced ORDER BY...
Date: 2006-01-15 10:53:03
Message-ID: 021501c619c1$dce426c0$6402a8c0@iwing
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> Something you may consider doing is creating a view that masks the
> screen_number in those cases, something like
>
> create view schedule_public_view as
> select theater_id
> , screen_date
> , screen_time
> , case when no_screen_number then 0 else screen_number end as
> screen_number
> , movie_name
> from schedules;

wouldn't this be the same problem: pgsql not using the index for
screen_number anymore?

- thomas

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Glaesemann 2006-01-15 10:59:24 Re: help with query: advanced ORDER BY...
Previous Message Michael Glaesemann 2006-01-15 03:36:17 Re: help with query: advanced ORDER BY...