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

Re: Searching for all records but integer field is causing

From: Jason Earl <jason(dot)earl(at)simplot(dot)com>
To: "Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Searching for all records but integer field is causing
Date: 2002-03-25 21:37:08
Message-ID: 87sn6oe3cr.fsf@npa01zz001.simplot.com (view raw or flat)
Thread:
Lists: pgsql-novice
I think that what you want is:

SELECT * FROM phpgw_categories WHERE cat_appname = 'notes';

Jason

"Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca> writes:

> 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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

pgsql-novice by date

Next:From: Masakazu IchimuraDate: 2002-03-26 01:15:10
Subject: Return value of function
Previous:From: Brian JohnsonDate: 2002-03-25 19:24:12
Subject: Searching for all records but integer field is causing problems

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