Re: select

From: Indraneel Majumdar <indraneel(at)www(dot)cdfd(dot)org(dot)in>
To: Jeff MacDonald <jeff(at)pgsql(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: select
Date: 2000-09-24 06:21:32
Message-ID: Pine.SGI.3.96.1000923232021.71353B-100000@www.cdfd.org.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

AFAIK, you can't enter a null value in a bool field, it has to be 1 or 0.

\Indraneel

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,
>

/************************************************************************.
# Indraneel Majumdar ¡ E-mail: indraneel(at)123india(dot)com #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics, #
# Hyderabad, India - 500076 #
`************************************************************************/

In response to

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

Responses

  • Re: select at 2000-09-23 17:49:32 from Jeff MacDonald

Browse pgsql-sql by date

  From Date Subject
Next Message Fredrick Bartlett 2000-09-24 15:18:53 Re: Select between two databases
Previous Message Philip Warner 2000-09-24 03:15:55 RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef?