From: | "Christian Hofmann" <christian(dot)hofmann(at)gmx(dot)de> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Problem: Joining each column of a "one row query" with the result of a "many row query" |
Date: | 2005-03-14 20:41:11 |
Message-ID: | 20050314204019.57AC5563D6@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello,
I have a query giving me the column_names with an unknown amount of rows.
This query is dynamically created by a pgsql function with the following
query inside:
select column_name from information_schema.columns where
table_schema='my_schema' and table_name='my_table' and "column_name" <>
'not_this_column1' and "column_name" <> 'not_this_column2' and "column_name"
<> 'not_this_column3'
Now I get some rows like:
column_name
------------
column_name1
column_name2
column_name3
.
.
.
There is an other query with one row result inside my pgsql function making
use of the result from the above query. The Part "column_name1,
column_name2, column_name3" the pgsql function can create on its own:
For example: select column_name1, column_name2, column_name3, ... from
my_schema.my_table where my_column1='abc' and my_column2=5
Now I get ONE row like this:
column_name1 | column_name2 | column_name3 | ...
-------------+--------------+--------------+----
value_clm1 | value_clm2 | value_clm3 | ...
In pgsql I do not get the column name in this query, right? That's sad,
because it would nearly solve my problem.
I need to find a way to get the result of the query in this way:
column_name | Value
-------------+-----------
column_name1 | value_clm1
column_name2 | value_clm2
column_name3 | value_clm3
.
.
.
In my opinion there are these ways?
1. combining both querys with a join, subselect or something like this?
2. Getting Postgres-SQL to write the column name into one row, how?
Can someone give me a hint to solve this problem? Or maybe someone has a
codesniplet?
Thank you for your help,
Christian
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Winfield-Blum | 2005-03-15 02:59:04 | Postgre and attachments |
Previous Message | Chris Travers | 2005-03-14 17:50:09 | Re: sql question |