Re: function corresponging to over in db2

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: function corresponging to over in db2
Дата
Msg-id 20050106122411.GA15754@svana.org
обсуждение исходный текст
Ответ на function corresponging to over in db2  ("vinita bansal" <sagivini@hotmail.com>)
Список pgsql-general
On Thu, Jan 06, 2005 at 08:00:13AM +0000, vinita bansal wrote:
> Hi,
>
> I have a query of the form "select min(tab1.a) over(partition by tab1.b
> tab2.a tab1.c) from .....
> in db2. What will be the corresponding query for postgres. Does Postgres
> have a function which provides the same functionality??

I've never heard of it, perhaps you could explain what it does? Perhaps
input and output example?

Hope this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "anon permutation"
Дата:
Сообщение: Re: Merging Data from Multiple DB
Следующее
От: Andre Felipe Machado
Дата:
Сообщение: postgresql-contrib risks?