Temp tables go away after the transaction completes. Perhaps you want a permanent table, dropped later with "drop table". Either that, or you may want to bracket the entire sequence in begin/end. I imagine that what you want to accomplish can be done. But your pseudo-code is very vague. Give the actual SQL to define the tables involved in your query. Then, describe carefully exactly what you want to accomplish. Then someone can give you a correct answer of exactly how to accomplish it. > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Hrishikesh Deshmukh > Sent: Monday, May 09, 2005 12:49 PM > To: Postgresql-General > Subject: WHERE > > Hi All, > > How can one use a table created for saving the results for a query be > used in WHERE for subsequent query!!! > > Step 1) create table temp as select gene from dataTable1 intersect > select gene from dataTable2; > > Now temp has been created, temp has only one column which has list of > genes and nothing else but i want to retrieve annotation for the genes > in temp table. > > Is it possible to: select geneAnnotation from dataTable1 where genes = > "gene in temp table";!!!!! > > Or am i here in some serious soup!!! :(( > > Thanks, > Hrishi > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
