Postgres Pro
Downloads
Home   >   mailing lists

Re: Analysis Function - Mailing list pgsql-performance

From David Jarvis
Subject Re: Analysis Function
Date
Msg-id AANLkTinPNQZv_9BS1fkoLPXzcBZe8FFv77PBRhPR-GpL@mail.gmail.com
Whole thread Raw
In response to Re: Analysis Function  (David Jarvis <thangalin@gmail.com>)
Responses Re: Analysis Function
List pgsql-performance
Tree view
Hi,

I added an explicit cast in the SQL:

        dateserial(extract(YEAR FROM m.taken)::int,'||p_month1||','||p_day1||') d1,
        dateserial(extract(YEAR FROM m.taken)::int,'||p_month2||','||p_day2||') d2

The function now takes three integer parameters; there was no performance loss.

Thank you.

Dave

pgsql-performance by date:

Previous
From: David Jarvis
Date:
Subject: Re: Analysis Function
Next
From: Szymon Kosok
Date:
Subject: ~400 TPS - good or bad?