From: | Andrei Kovalevski <andyk(at)commandprompt(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Cc: | Adam M <gnuman1(at)gmail(dot)com>, Malm Paul <paul(dot)malm(at)saabgroup(dot)com> |
Subject: | Re: get number of rows selected |
Date: | 2008-04-07 01:30:16 |
Message-ID: | 47F97928.6010905@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello,
Take a look at SQLRowCount(
http://msdn2.microsoft.com/en-us/library//ms711835.aspx ). You may note:
*/For other statements and functions, the driver may define the value
returned in *RowCountPtr. For example, some data sources may be able to
return the number of rows returned by a SELECT statement or a catalog
function before fetching the rows./*
You may rely on this when using psqlODBC or ODBCng with buffering mode
ON (default).
Adam M wrote:
> 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
>
--
Andrei Kovalevski
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Andrei Kovalevski | 2008-04-07 01:35:57 | Re: Connection of postgres |
Previous Message | noreply | 2008-04-03 17:20:30 | [ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0 |