On 5/3/15 4:15 PM, Anton wrote:
Hello guru of postgres, it's possoble to tune query with join on random string ? i know that it is not real life example, but i need it for tests.
Moving to -general, which is the proper list for this. (BCC -hackers) > soe-# WHERE customer_id = trunc( random()*45000) ; You could create a temp table with the random value and JOIN to it: CREATE TEMP TABLE rnd AS SELECT random()*45000; Another option might be to use a prepared statement: PREPARE test AS SELECT ... WHERE customer_id = $1; EXECUTE test( random()*45000 ); -- Jim Nasby, Data Architect, Blue Treble Consulting Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
