Re: How to make a IN without a table... ?

From: David Pradier <dpradier(at)apartia(dot)fr>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to make a IN without a table... ?
Date: 2003-06-16 07:27:40
Message-ID: 20030616072740.GA658@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)apartia(dot)fr 01.46.47.21.33

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Nicolas JOUANIN 2003-06-16 10:34:34 Let join syntax
Previous Message Julian Scarfe 2003-06-15 16:48:40 Re: Ordering in an aggregate -- points to paths