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

Поиск
Список
Период
Сортировка
От David Pradier
Тема Re: How to make a IN without a table... ?
Дата
Msg-id 20030616072740.GA658@apartia.fr
обсуждение исходный текст
Ответ на Re: How to make a IN without a table... ?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Ordering in an aggregate -- points to paths
Следующее
От: "Nicolas JOUANIN"
Дата:
Сообщение: Let join syntax