Hi Thank you for the answer, after a longer tracing, (go based and printing pg queries to log, I realize that it happens on a different place that I thought it does.
Ido On Sat, Sep 15, 2018 at 12:13 AM Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 9/14/18 12:11 PM, ik wrote: > > Hello, > > > > Not sure that this is the right mailing list, so sorry from advance. > > > > I have a program that when it does a query I have one raw returns, but > > when I execute the same query with the same conditions, I get the right > > number of rows back. > > The above is going to need more information to work out: > > 1) The query that returns one row is running in a Go program using the > Go driver below, correct? > > 2) The other query that returns correctly is being run where and how? > > 3) What is the actual query? > > 4) How is the query setup in the program? > > 5) Are you sure the incorrect and correct queries are running against > the same database? > > > > > I'm using gonlang and https://github.com/jackc/pgx . > > The query inside is inside an already open cursor of another "select" > > query that I iterate over. > > > > Is there a way to debug just that inside pg-logs without having all > > possible queries logged in? > > If it is a SELECT query then no. > > > > > Thank you > > Ido > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >