Re: How to make a IN without a table... ? - Mailing list pgsql-sql

From David Pradier
Subject Re: How to make a IN without a table... ?
Date
Msg-id 20030616072740.GA658@apartia.fr
Whole thread Raw
In response to Re: How to make a IN without a table... ?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-sql
> > I avoid as hell to use temporary tables. This is part of a complex
> > database, with more than 250 different tables. So i don't even want to
> > think about adding temporary tables, brrr !
> 
> Just FYI, temporary tables in pgsql are invisible to other connections 
> even if they have the same name, and are auto-dropped when the connection 
> is dropped.

Well, i didn't know this.
I will check how it works.

Thanks a lot, Scott.

-- 
dpradier@apartia.fr 01.46.47.21.33


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Ordering in an aggregate -- points to paths
Next
From: "Nicolas JOUANIN"
Date:
Subject: Let join syntax