Re: [SQL] Need help in composing PostgreSQL query

2001-09-04 Thread Oliver Elphick
"Vladimir V. Zolotych" wrote: >Hi > >Please help me compose the query in PostgreSQL. >Using PostgreSQL 7.1.2. > >Suppose relations A and B have columns: > {X1, X2, ..., Xm, Y1, Y2, ..., Yn} >and > {Y1, Y2, ..., Yn} >Attributes Y1, Y2, ..., Yn are common for both relations >

[SQL] Need help in composing PostgreSQL query

2001-09-03 Thread Vladimir V. Zolotych
Hi Please help me compose the query in PostgreSQL. Using PostgreSQL 7.1.2. Suppose relations A and B have columns: {X1, X2, ..., Xm, Y1, Y2, ..., Yn} and {Y1, Y2, ..., Yn} Attributes Y1, Y2, ..., Yn are common for both relations and have the same type in both. How can I define in PostgreSQL