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