Re: select

From: Jie Liang <jliang(at)ipinc(dot)com>
To: Jeff MacDonald <jeff(at)pgsql(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: select
Date: 2000-09-25 18:45:49
Message-ID: 39CF9D5C.B52EF411@ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi, there,

only possible is null, so select blah from tableblah where field is
null;

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

--
Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.ipinc.com

In response to

  • select at 2000-09-23 17:37:29 from Jeff MacDonald

Browse pgsql-sql by date

  From Date Subject
Next Message Forest Wilkinson 2000-09-25 18:46:50 SQL functions not locking properly?
Previous Message Meszaros Attila 2000-09-25 16:56:16 Subqueries in from clause?