Re: [SQL] Best way to know if there is a row

2004-09-28 Thread Tom Lane
Martin Marques <[EMAIL PROTECTED]> writes: > I need to know if there is at least one row in the relation that comes from a > determinated query. Which is the best way to do this: > (a) Build the query with "SELECT * ..." and after executing the query see if > numRows()>0 > (b) Build the query wi

Re: [SQL] Best way to know if there is a row

2004-09-28 Thread Achilleus Mantzios
O Martin Marques έγραψε στις Sep 28, 2004 : > I have a bunch of queries in a system I'm finishing, and I bumped with a > question on performace. > Which is the best way to solve this: > > I need to know if there is at least one row in the relation that comes from a > determinated query. Which i

[SQL] Best way to know if there is a row

2004-09-28 Thread Martin Marques
I have a bunch of queries in a system I'm finishing, and I bumped with a question on performace. Which is the best way to solve this: I need to know if there is at least one row in the relation that comes from a determinated query. Which is the best way to do this: (a) Build the query with "SEL