Re: [PERFORM] Saving result set of SELECT to table column

2008-01-14 Thread Robins Tharakan
Hi Patric, This doesn't seem to be a question pertaining to the PERFORM queue. If I understand you correctly, this should solve your problems, without the need for any RULES / TRIGGERS. CREATE TABLE y ( y1 int4 NOT NULL, y2 varchar, CONSTRAINT a PRIMARY KEY (y1) ) CREATE TABLE z ( z1 i

Re: [PERFORM] Saving result set of SELECT to table column

2008-01-14 Thread Ansgar -59cobalt- Wiechers
On 2008-01-14 Patric wrote: > Well I've a normalized database.. > For instance: > > create table Y ( pk, data... ); > create table Z ( pk , data...); > > create table X ( char, references Y, references Z); > > SELECT * from X; > > Now I want to make a listing of the resul