Searching for all records but integer field is causing problems - Mailing list pgsql-novice

From Brian Johnson
Subject Searching for all records but integer field is causing problems
Date
Msg-id 000801c1d432$a5ae4740$3200a8c0@jecinc.on.ca
Whole thread Raw
Responses Re: Searching for all records but integer field is causing
List 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


pgsql-novice by date:

Previous
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: rules over multiple tables
Next
From: Jason Earl
Date:
Subject: Re: Searching for all records but integer field is causing