On Wednesday 05 January 2005 2:51 pm, [EMAIL PROTECTED]
wrote:
> Thanks, Ragnar,
>
> You are right in what is happening. The code was supposed to be
> sending '' but it is sending NULL instead. I see now -- in
> PostgreSQL to look for any record without the 'X' I have to use a
> combined condition
Thanks, Ragnar,
You are right in what is happening. The code was supposed to be sending ''
but it is sending NULL instead. I see now -- in PostgreSQL to look for any
record without the 'X' I have to use a combined condition because a NULL is
not included in a != statement.
select count(*) from re
On Wed, 2005-01-05 at 22:32 +, Ragnar Hafstað wrote:
> select count(*) from resource where reengine is NULL 'X';
typo. I meant of course:
select count(*) from resource where reengine is NULL;
gnari
---(end of broadcast)---
TIP 5: Have you
[EMAIL PROTECTED] writes:
> I have a small table in which I have a Character(1) field called reengine.
> The field either has an "X" or is empty. This field does not have NULL
> values. There are 27 records in the table, 25 are marked with an 'X' in
> reengine.
> When I write
> select count(*) fro
On Wed, 2005-01-05 at 13:51 -0800, [EMAIL PROTECTED] wrote:
> I have a small table in which I have a Character(1) field called reengine.
> The field either has an "X" or is empty. This field does not have NULL
> values. There are 27 records in the table, 25 are marked with an 'X' in
> reengine.
>
Try:
select count(*) from resource where reengine <> 'X';
Alex Turner
NetEconomist
On Wed, 5 Jan 2005 13:51:58 -0800, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> I have a small table in which I have a Character(1) field called reengine.
> The field either has an "X" or is empty. This field
I have a small table in which I have a Character(1) field called reengine.
The field either has an "X" or is empty. This field does not have NULL
values. There are 27 records in the table, 25 are marked with an 'X' in
reengine.
I am querying the table from pgadmin v1.1.0 for windows.
When I write
