Skip site navigation (1) Skip section navigation (2)

Re: get number of rows selected

From: "Adam M" <gnuman1(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: get number of rows selected
Date: 2008-04-03 16:30:07
Message-ID: 84b37b360804030930o1b771e47ib9082bf3cecb54f6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Generally you would do that with a count function instead of relying
on something else.

"select * from layer where visible = 1"

so I guess "SELECT COUNT(*) FROM layer WHERE visible=1" would give you
the answer.

- Adam

In response to

Responses

pgsql-odbc by date

Next:From: noreplyDate: 2008-04-03 17:20:30
Subject: [ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0
Previous:From: Nguyen, Lam ThuyDate: 2008-04-03 14:04:05
Subject: Connection of postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group