| From: | Jeff MacDonald <jeff(at)pgsql(dot)com> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | Jeff MacDonald <jeff(at)pgsql(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: select |
| Date: | 2000-09-23 18:52:59 |
| Message-ID: | Pine.BSF.4.21.0009231552510.53901-100000@rage.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
bingo,
thaks
On Sat, 23 Sep 2000, Stephan Szabo wrote:
>
> I'd assume this would work:
> select * from table where booleanfield is null;
>
> Stephan Szabo
> sszabo(at)bigpanda(dot)com
>
> On Sat, 23 Sep 2000, Jeff MacDonald wrote:
>
> > how would i select all rows where a boolean value is neither
> > t nor f.. ?
> >
> > ie if someone inserted without setting the boolean tag.
>
>
Jeff MacDonald,
-----------------------------------------------------
PostgreSQL Inc | Hub.Org Networking Services
jeff(at)pgsql(dot)com | jeff(at)hub(dot)org
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Fascimile : 1 902 542 5386
IRC Nick : bignose
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Warner | 2000-09-24 03:15:55 | RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef? |
| Previous Message | Stephan Szabo | 2000-09-23 18:49:59 | Re: select |