Re: Improper processing of random values in sub-queries

Поиск
Список
Период
Сортировка
От davidn-postgres@rebel.net.au
Тема Re: Improper processing of random values in sub-queries
Дата
Msg-id Pine.LNX.4.58.0407101332450.12278@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Improper processing of random values in sub-queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I assume though that this is a made-up example and is not the case
> that's really troubling you.  What is the actual problem you are looking
> at?

I was generating random test data and naively assumed that ()::integer
truncated its value, therefore I was getting duplicate values.  Once I
I realised that random()::integer was rounded I had no further problem,
but figured should report the bug that I had already noticed.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: SELECT DISTINCT on boxes
Следующее
От: davidn-postgres@rebel.net.au
Дата:
Сообщение: Re: Can't join on null values