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

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 (view raw or flat)
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

pgsql-sql by date

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

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