Re: [GENERAL] parametered views

2007-06-12 Thread [EMAIL PROTECTED]
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,

Re: [GENERAL] parametered views

2007-06-12 Thread [EMAIL PROTECTED]
On Jun 9, 8:12 am, Rodrigo De León <[EMAIL PROTECTED]> wrote: > On Jun 8, 7:59 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > 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_Tabl

Re: [GENERAL] parametered views

2007-06-11 Thread Alban Hertroys
Rodrigo De León wrote: > On Jun 8, 7:59 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > 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 r

Re: [GENERAL] parametered views

2007-06-09 Thread Rodrigo De León
On Jun 8, 7:59 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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

Re: [GENERAL] parametered views

2007-06-08 Thread Rodrigo De León
[EMAIL PROTECTED] ha escrito: > Hello, > > my problem is : in depend of the value of a field in a table A, I > want to select other fields coming from a table B, or a table C. > > I want to know if it's possible to create a parametred view in > postgresql to resolve this problem > > > Thx, > Lhaj