Re: [GENERAL] Double Denormalizing in Postgres

2011-12-15 Thread David Johnston
On Dec 15, 2011, at 11:27, Pavel Stehule wrote: > 2011/12/15 Robert James : >> To match the heavily denormalized format of a legacy app, I need to >> take a query which gives this: >> >> name | product | rent | own >> Bob | Car | true | false >> Bob | Car | false | true >> Bob | Bike | false | t

Re: [GENERAL] Double Denormalizing in Postgres

2011-12-15 Thread Pavel Stehule
2011/12/15 Robert James : > To match the heavily denormalized format of a legacy app, I need to > take a query which gives this: > > name | product | rent | own > Bob | Car | true | false > Bob | Car | false | true > Bob | Bike | false | true > Bob | Truck | true | true > > and denormalize it into