pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: giuseppe.derossi@email.it
To: pgsql-admin@postgresql.org
Subject: dynamic name of table in select
Date: Thu, 3 Jan 2008 10:11:05 +0100
Message-ID: <3fce0e1505967341e43d6d87c5bd4afc@164.129.1.41> (raw)

Hi to all,
I need help about the following issue:
in my db I've three table which have the same column (there are some reasons
for that) I'd like to perform a select statement like that: select my_column
from xxx_table . 
Where xxx could be choosen from another table result. 
for example :

select my_column from (select name_table from catalog where condition1)

now the internal select has to return the name of the table which is linked
to the condition1 (let me say condition1_table) so after the inner select
has been perfomed, I should have 

select my_column from condition1_table

Is it possible ?

Second question: is there a system variable where the name of the db is
stored ? how can I recall it?

Thanks in advance and best regards

Giu 
 --
 Email.it, the professional e-mail, gratis per te: http://www.email.it/f
 
 Sponsor:
 Realizza i tuoi sogni con i finanziamenti Finatel! Fino a 50.000 Euro senza
spese in pochissimo tempo. Richiedi Informazioni 

 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7371&d=20080103





Message-ID: <3fce0e1505967341e43d6d87c5bd4afc@164.129.1.41>
Permalink:  ../3fce0e1505967341e43d6d87c5bd4afc@164.129.1.41/
Also on:    postgresql.org/message-id/3fce0e1505967341e43d6d87c5bd4afc@164.129.1.41

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: giuseppe.derossi@email.it
  Subject: Re: dynamic name of table in select
  In-Reply-To: <3fce0e1505967341e43d6d87c5bd4afc@164.129.1.41>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox