Didn't you create those other tables with "character varying" too? If
you did i think that you need to change those tables too.
On Mon, Nov 10, 2008 at 12:44 PM, A. Kretschmer
<[EMAIL PROTECTED]> wrote:
> am Mon, dem 10.11.2008, um 15:34:10 +0100 mailte Mario Splivalo folgendes:
>> I have a table
--- On Fri, 11/28/08, Lutz Steinborn <[EMAIL PROTECTED]> wrote:
> From: Lutz Steinborn <[EMAIL PROTECTED]>
> Subject: [SQL] wired behaviour
> To: pgsql-sql@postgresql.org
> Date: Friday, November 28, 2008, 1:51 PM
> Hello,
>
> I have an problem understanding a simple query:
>
> For example I
Lutz Steinborn wrote:
Hello Paul,
thanks for the quick answer.
NULL values?
Jepp, thats it.
I've supposed this but can't believe it. So NULL is something out of this
dimension :-)
Kindly regards
Lutz
NULL refers to an unknown value - it cannot be said to equal or not
equal anything other
On fös, 2008-11-28 at 15:22 +0100, Lutz Steinborn wrote:
> Hello Paul,
>
> thanks for the quick answer.
>
> > NULL values?
> Jepp, thats it.
> I've supposed this but can't believe it. So NULL is something out of this
> dimension :-)
Yes, that is one way of putting it.
A more useful way to look
Hello Paul,
thanks for the quick answer.
> NULL values?
Jepp, thats it.
I've supposed this but can't believe it. So NULL is something out of this
dimension :-)
Kindly regards
Lutz
>
> Met vriendelijke groet,
>
> Paul Dam
> Informatieanalist
>
>
>
>
> Amyyon
> Bijsterhuizen 11.58
> 6546
On Nov 28, 2008, at 8:51 AM, Lutz Steinborn wrote:
Hello,
I have an problem understanding a simple query:
For example I have the following:
select count(*) from foo;
gives me 1000
select count(*) from foo where bar = 'Mr Spock';
gives me 5
select count(*) from foo where NOT bar = 'Mr Spock'
NULL values?
Met vriendelijke groet,
Paul Dam
Informatieanalist
Amyyon
Bijsterhuizen 11.58
6546 AS Nijmegen
050 - 311 5686
www.amyyon.nl
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Namens Lutz Steinborn
Verzonden: vrijdag 28 november 2008 14:52
Aan: pg
Hello,
I have an problem understanding a simple query:
For example I have the following:
select count(*) from foo;
gives me 1000
select count(*) from foo where bar = 'Mr Spock';
gives me 5
select count(*) from foo where NOT bar = 'Mr Spock';
gives me 857
Why I'm not getting 955 for the last qu
O Problema é tem tenho uma tabela muito grande com chave primaria e tudo
mais...
e quando eu vou fazer uma atualização de alguns campos desta tabela o banco
fica devagar estou procurando algum comando que me permita atualizar os
registros aos poucos por exemplo uma tabela com 100 000 atualiza-l
