pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Broersma Jr <rabroersma@yahoo.com>
To: Mark Steben <msteben@autorevenue.com>
To: pgsql-admin@postgresql.org
Subject: Re: Index on a COALESCE function
Date: Mon, 16 Jul 2007 13:12:26 -0700 (PDT)
Message-ID: <886237.78443.qm@web31813.mail.mud.yahoo.com> (raw)
In-Reply-To: <004f01c7c7e3$8b38fd60$b501a8c0@D1RPQZB1>

--- Mark Steben <msteben@autorevenue.com> wrote:

>  select 45198705,false,id,next_avail_senddate(id,date(send_date)) from 
>  (select
> id,timeclause_combine(date(estmileage_timeclause(service_date,mileage,last_s
> ervice_date,last_mileage,
>    date_of_purchase,year_purchased,10750,cid,serindex_date,id)),
>    date(date_larger(date(coalesce(date_of_purchase,
> '1900-01-01')+timespan('45 days')),
>    date(service_date+timespan('44 days')))),
>    date(null),date(create_date),9,false) as send_date,last_send

IIUC, indexs are only used in JOINS and WHERE conditions.  I don't see either of those in your
query.

Regards,
Richard Broersma Jr.



view thread (2+ messages)

Message-ID: <886237.78443.qm@web31813.mail.mud.yahoo.com>
Permalink:  ../886237.78443.qm@web31813.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/886237.78443.qm@web31813.mail.mud.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: rabroersma@yahoo.com, msteben@autorevenue.com
  Subject: Re: Index on a COALESCE function
  In-Reply-To: <886237.78443.qm@web31813.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox