Home > mailing lists

Temp tables - Mailing list pgsql-admin

From	jose fuenmayor
Subject	Temp tables
Date	August 15, 2020 02:26:36
Msg-id	CAK74dbmv6JStQ_7FW9-UbuY2bXoMLnW_fQ54qGCW_X8bhDngoA@mail.gmail.com Whole thread Raw
Responses	RE: Temp tables ("2.andriychuk" <2.andriychuk@gmail.com>)
List	pgsql-admin

Hi all , i have a doubt wich query performs better

Update table a set field1=b.field 1

From (select field1,field2

From table2 where x=z

) b

Where a.field2=b.field2

Create temp table y as

select field1,field2

From table2 where x=z;

Update table a

set field1=b.field1

From y as b

Where a.field2=b.field2

I ve been told not to use subquerys, but i think this refers to

Select * from table where field1 in (select field1 from table2)

Any thoughts?

Thanks people y'all

From: Jerry Sievers
Date: 15 August 2020, 01:55:25
Subject: Re: Seeing where a given trigger function is in use?

From: "2.andriychuk"
Date: 15 August 2020, 03:01:01
Subject: RE: Temp tables