Hi!
Q1. Is subquery better or join?
For subquery:
SELECT t1.c1,(SELECT t2.c2 FROM t2 WHERE t2.c1 = t1.c1) FROM t1
I wonder it will loop n times if t1 returns n rows. If this is the case, is it better
to use join like this:
SELECT t1.c1,t2.c2 FROM t1,t2 WHERE t2.c1 = t1.c1
Q2. If the query i
Greetings!
I must have missed lesson 1 of postgresql!
create table test (c1 text,c2 bytea);
Then, I probably have successfullyi nserted several records into test using
C++Builder. Now I am trying to retrieve back the binary data in c2 I just inserted.
However, the SQL statement issued by both
