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(at)bcbsm(dot)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