Re: Partition by outer join

Поиск
Список
Период
Сортировка
От aditya desai
Тема Re: Partition by outer join
Дата
Msg-id CAN0SRDGNULQKOyZ6gykyQsgtGyykbQ3XWWtBuQBRLFcXzo7-wQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Partition by outer join  (hubert depesz lubaczewski <depesz@depesz.com>)
Ответы Re: Partition by outer join  (Steve Midgley <science@misuse.org>)
Список pgsql-sql
Agree!! I will try to get data, which looks difficult actually. Thanks for your response.

On Tue, Aug 24, 2021 at 12:02 PM hubert depesz lubaczewski <depesz@depesz.com> wrote:
On Mon, Aug 23, 2021 at 09:22:47PM +0530, aditya desai wrote:
> While trying to migrate Oracle to Postgres wera stuck with PARTITION BY
> OUTER JOIN. Can someone help rewriting or helping with Postgres
> equivalent of below query? Thanks in advance.

It would make MUCH more sense to show us data and expected output.
Why do you assume Pg dbas know and understand intricacies of Oracle?

depesz

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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Partition by outer join
Следующее
От: Martin Norbäck Olivers
Дата:
Сообщение: question about to_tsvector and to_tsquery