Re: transposing data for a view

Поиск
Список
Период
Сортировка
Искать
От
Josh Berkus
Тема
Re: transposing data for a view
Дата
Msg-id
web-496648@davinci.ethosmedia.com
Ответ на
Re: transposing data for a view (jeremy@wundt.psychiatry.uiowa.edu (H Jeremy Bockholt))
Список
Дерево обсуждения
Re: transposing data for a view jeremy@wundt.psychiatry.uiowa.edu (H Jeremy Bockholt)
Re: transposing data for a view "Josh Berkus" <josh@agliodbs.com>
Optimization, etc "Jeff Sack" <sackj@alum.rpi.edu>
Re: Optimization, etc Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Optimization, etc Masaru Sugawara <rk73@echna.ne.jp>
Re: Optimization, etc Jason Earl <jason.earl@simplot.com> 
Jeremy,

> I see how your idea could work--the only thing I would change would
> be region needs to be scanid on the first line; however,
> I'm using PostgreSQL v7.03, so I can not do subqueries within FROM
> clause.
> 
> Other than creating a temporary table, is there a way to
> restructure this solution to get around this limitation?

No, you need to upgrade.  What's the obstacle to using 7.1.3, anyway?

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco
В списке pgsql-sql по дате отправления
Предыдущее
От: Josh Berkus
Дата:
Следующее
От: Jeff Eckermann
Дата:
FAQ