Re: [SQL] Problem with n to n relation

2001-10-05 Thread Morgan Curley
relation. But how van i achieve that you canĀ“t >insert any person without adress??? > >thanks in advance >janning > >-------(end of broadcast)--- >TIP 4: Don't 'kill -9' the postmaster - Morgan Curley Par

[SQL] Query Approach and performance

2001-08-17 Thread Morgan Curley
Hey everyone, On average, are multiple simple queries better performance-wise than joins? i.e. select A.col1 from table1 A select B.col2 from table2 B where B.col1 = A.col1 etc vs select A.col1, B.col2 from table1 A, table2 B where B.col1 = A.col1 Are joins better for small/large numbers of tab

[SQL] Procedures in views

2001-07-23 Thread Morgan Curley
Does anyone know if the following is possible: Table A has a list of names with a column entry containing the name of an assoc pl/pgsql function Table B has a list of values Table C is a junction table btw A and B I would like to create a view that returns info from both tables and does a calc