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
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
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