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

Searching for all records but integer field is causing problems

From: "Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Searching for all records but integer field is causing problems
Date: 2002-03-25 19:24:12
Message-ID: 000801c1d432$a5ae4740$3200a8c0@jecinc.on.ca (view raw or flat)
Thread:
Lists: pgsql-novice
How do I do a select query for all records?

SELECT * FROM phpgw_categories WHERE cat_name = ? AND cat_owner = ? AND
cat_appname = 'notes'

cat_name = '*' works but cat_owner = '*' gives me an atoi error.

I was hoping to reuse the code segment of SQL that gets called repeatedly
for slightly different purposes but I can't get this to work


Responses

pgsql-novice by date

Next:From: Jason EarlDate: 2002-03-25 21:37:08
Subject: Re: Searching for all records but integer field is causing
Previous:From: Henshall, Stuart - WCPDate: 2002-03-25 15:14:56
Subject: Re: rules over multiple tables

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