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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: PQntuples return type


  • From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: Re: PQntuples return type
  • Date: Mon, 30 Jul 2007 14:21:56 -0000
  • Message-id: <db0eb91047d052e22ad6b960a06d5d8a(at)biglumber(dot)com>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> So, my doubt is: if the return type is int instead of unsigned int, 
> is this function testable for negative return values?

A quick glance at the code in fe-exec.c and fe-protocol3.c shows that 
the underlying variable starts at 0 as an int and in incremented by 
one every row, so it seems possible that it could wrap around for 
very large results sets and/or boxes with a low representation of 'int'. 
There may be some other safeguards in place I did not see to prevent this, 
but I don't see a reason why we shouldn't use unsigned int or 
unsigned long int here, both for ntups and the return value of the 
function.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation
PGP Key: 0x14964AC8 200707300937
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFGrfPXvJuQZxSWSsgRA6gZAJ9O5dkgEIstoqhcYjz87V2REUhLWQCgr+uW
1eIVpiahum4ML0Zz7ANlrl0=
=YqJu
-----END PGP SIGNATURE-----





Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group