Re: funny view/temp table problem with query - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: funny view/temp table problem with query
Date
Msg-id 2f4958ff0902260202q42e076f6l6460f8d47cac795e@mail.gmail.com
Whole thread Raw
In response to Re: funny view/temp table problem with query  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Responses Re: funny view/temp table problem with query
Re: funny view/temp table problem with query
List pgsql-general
looks like you completely misunderstood my question.
First of all, I wonder why the same query divided up in half - and
using temporary table works as expected, and with everything together
doesn't. And about rand(), it was tested on large enough set of runs,
that I don't think it is to blame.
The queries do everything I wanted it to do, and - no - doing it in
software is just baaad, and doesn't do.

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Format string for ISO-8601 date and time
Next
From: Eus
Date:
Subject: Re: Can I use a query with UPDATE on its SET?