Re: Update table with random values from another table - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: Update table with random values from another table
Date
Msg-id 2f4958ff0902120547q6a9f4bd1pcf9ffce8cf5c6078@mail.gmail.com
Whole thread Raw
In response to Re: Update table with random values from another table  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: Update table with random values from another table
List pgsql-general
actually forget about that generate_series() in sub queries, I just
realized that it won't do.
I don't have too much time to analyse and find solution, but
essentially you need to do it like in my example.

See, that's where normalization would help a lot. Ie, having a
separate table for name, and surname - and than third one to connect
them into full name.

pgsql-general by date:

Previous
From: Joshua Tolley
Date:
Subject: Re: Two-phase commmit, plpgsql and plproxy
Next
From: Karsten Hilbert
Date:
Subject: Re: encoding of PostgreSQL messages