Re: parametered views

From: "lhaj(dot)merigh(at)gmail(dot)com" <lhaj(dot)merigh(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: parametered views
Date: 2007-06-09 11:25:08
Message-ID: 1181388308.073491.143840@g4g2000hsf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jun 9, 8:12 am, Rodrigo De Len <rdele(dot)(dot)(dot)(at)gmail(dot)com> wrote:
> On Jun 8, 7:59 pm, "lhaj(dot)mer(dot)(dot)(dot)(at)gmail(dot)com" <lhaj(dot)mer(dot)(dot)(dot)(at)gmail(dot)com>
> wrote:
>
>
>
> > i have 4 tables :
>
> > date_table (date_id,.....)
> > A_table(A_table_id, something1,something2.........)
> > A1_table(A1_table_id references A_Table(A_Table_id),A11,A12........)
> > A2_table(A2_table_id references A_Table(A_table_id),A21,A22,.......)
>
> > so i want to create a view with date_id,A_table_id,something1,
> > if something2=x then my view containts
> > (A1_table.A11 and A1_table.A12)
> > else it's containts (A2_table.A21 and A2_table.A22))
>
> > so my view depends of something2 value.
>
> > I hope i'm specific
>
> > Thx
> > Lhaj
>
> create view foobar as
> select date_id,A_table_id,something1
> ,case when something2=x then A1_table.A11 else A2_table.A21 end as foo
> ,case when something2=x then A1_table.A12 else A2_table.A22 end as bar
> from (... etc., etc. ...)

OK, thank you (the idea is here i will try to do that)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2007-06-09 13:39:44 Re: pg_hba.conf - md5
Previous Message Vince 2007-06-09 09:43:06 pg_hba.conf - md5