From: Pavel Stehule <pavel.stehule@gmail.com>
To: msi77 <msi77@yandex.ru>
Cc: Yuan HOng <hongyuan1306@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: F_TABLE_NUMBER_RANGE equivalent in Postgresql
Date: Tue, 16 Aug 2011 07:21:56 +0200
Message-ID: <CAFj8pRB+LGLenjHYo2WbCDsEnQt5m7BSzDC7O-CUQSfUTgjsbA@mail.gmail.com> (raw)
In-Reply-To: <964111313471940@web94.yandex.ru>
References: <CANvi9-2uJUWGc8_VJMPq1NGnxVt=KjQihKvorjyLc3WL2MG4DA@mail.gmail.com>
<964111313471940@web94.yandex.ru>
Hello
this is not built in MSSQL, but PostgreSQL has a "generate_series" function
Regards
Pavel Stehule
2011/8/16 msi77 <msi77@yandex.ru>:
>
> Are you sure that dbo.F_TABLE_NUMBER_RANGE is in SQL Server?
> I suppose that this is UDF written by user.
>
>
> 16.08.2011, 08:53, "Yuan HOng" <hongyuan1306@gmail.com>:
>> Hi,
>>
>> With MS-SQL sever, there is a built-in utility function
>> dbo.F_TABLE_NUMBER_RANGE which generates a list of number between the
>> given range. For example:
>>
>> select dbo.F_TABLE_NUMBER_RANGE(1, 5) will return:
>>
>> number
>> -----------
>> 1
>> 2
>> 3
>> 4
>> 5
>>
>> This is extremely convenient for generating consecutive dates. For
>> example, I want to find out the daily sales information and if on some
>> day there is no sales, the query should return 0 instead of a missing
>> date.
>>
>> In this case it is necessary to first create a list of consecutive
>> dates and then left join to some fact table.
>>
>> With the range function I can simply write something like
>>
>> select start_date + interval number
>> from dbo.F_TABLE_NUMBER_RANGE(1, number_of_days)
>>
>> How does one accomplish such task with Postgresql?
>>
>> --
>> Hong Yuan
>>
>> 大管家网上建材超市
>> 装修装潢建材一站式购物
>> http://www.homemaster.cn
>>
>> --
>> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-sql
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
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-sql@postgresql.org
Cc: pavel.stehule@gmail.com, msi77@yandex.ru, hongyuan1306@gmail.com
Subject: Re: F_TABLE_NUMBER_RANGE equivalent in Postgresql
In-Reply-To: <CAFj8pRB+LGLenjHYo2WbCDsEnQt5m7BSzDC7O-CUQSfUTgjsbA@mail.gmail.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