Re: pg_query_params

In response to Carol Walter <walterc@indiana.edu>:
>
> On Jul 22, 2009, at 3:29 PM, Bill Moran wrote:
>
> > In response to Carol Walter <walterc@indiana.edu>:
> >
> >> Does pg_query_params return a false if an item is not found in a
> >> database?
> >
> > What's an item?  That term is does not describe any type of standard
> > database object.
> >
> > pg_query_params() will return false if the query was invalid for any
> > reason.  One such possible reason is that you tried to access a
> > table that doesn't exist.
> >
> > If you're getting false as the return value, you should use
> > pg_last_error() to discover the details of the error.

> No, I mean if I select select a name from the database but the name
> isn't found.  I'm doing a log in form.  I want to check to see if the
> user that's logging in exists in my database.  I can check the number
> of rows returned or something like that, but I wondered if the
> function returns a false.

Please don't top-post.

I assume that (for some reason) you're avoiding using the term "table"
and that you're running a select query against a table and finding that
a particular row is or is no in that table?

If that's correct, you should work on communicating more clearly.  Also,
if that is correct, I already answered your question:

"pg_query_params() will return false if the query was invalid for any
reason."

Meaning, "no, it won't return false if a matching row isn't found, because
the query was still valid."

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/