Re: selecting multiple like-named columns

You may have denormalized your data, for example if you have one table
like this:

date | chicago_sales | ny_sales | boston_sales | etc

It may be more convenient to store it like this:

date | city | sales

then you can say

  select sales from table where city = 'ny';

or what you want by not specifying a filter:

  select sales from table;

or

  select sum(sales) from table;
  select sum(sales) from table where city in ('ny', 'chicago');


There is only one reason you may want to keep it denormalized  .. and
that is for performance if the report you need looks like the original
table above.


--- "Johnson, Shaunn" <SJohnson6@bcbsm.com> wrote:
>
> Howdy:
>
> Running PostgreSQL 7.2.1 on RedHat Linux 7.2.
>
> Is there a way to do a select for the column
> names from a table by using some type of
> wild card?
>
> Let's say I have something like column_1, column_2,
> other_column_1, other_column_2 ...
>
> [example]
>
> select
> column_%,
> other_column_%,
> from
> t_table
> ;
>
> [/example]
>
> I'm trying to figure out how to get all of the
> data from the columns that have similar
> names.
>
> Thanks!
>
> -X
>


__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com