Dnia Sat, Mar 19, 2005 at 06:36:27PM +0100, [EMAIL PROTECTED] napisal(a/o):
> 1. I've a master table containing about 4 records. A count(*) provides
> me the exact number.
> 2. I've create a table based on from the master. I copied a fraction from
> the master into the new table using a where c
TECTED]>
>To: [EMAIL PROTECTED]
>Cc: pgsql-general@postgresql.org
>Subject: Re: Betr: Re: [GENERAL] Question insert data
>
>
>On Sun, 20 Mar 2005 [EMAIL PROTECTED] wrote:
>
>> That's what I tought the problem was, but I created a table afterwards
>without
>>
On Sun, 20 Mar 2005 [EMAIL PROTECTED] wrote:
> That's what I tought the problem was, but I created a table afterwards
> without
> inheritence. Could it have something to do with the max size of the schema
> or oid's?
I can't think of a reason it would, so can you send a self-contained
full exam
ROTECTED]>
>To: [EMAIL PROTECTED]
>Cc: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Question insert data
>
>
>On Sat, 19 Mar 2005 [EMAIL PROTECTED] wrote:
>
>> Hi There,
>>
>> I've a problem with inserting data and I can't figure out what
On Sat, 19 Mar 2005 [EMAIL PROTECTED] wrote:
> Hi There,
>
> I've a problem with inserting data and I can't figure out what the problem
> is:
>
>
> what did I do:
>
>
> 1. I've a master table containing about 4 records. A count(*) provides
> me the exact number.
>
> 2. I've create a table base
d, 5127 ms execution time.
>-- Oorspronkelijk bericht --
>Subject: Re: [GENERAL] Question insert data
>From: Ragnar Hafstað <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Cc: pgsql-general@postgresql.org
>Date: Sat, 19 Mar 2005 17:56:52 +
>
>
>On Sat, 2005-03-19
insert into master_nl
select * from master where substr(loc,1,2) = 'NL'
>-- Oorspronkelijk bericht --
>Subject: Re: [GENERAL] Question insert data
>From: Ragnar Hafstað <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Cc: pgsql-general@postgresql.org
>Date: Sat, 19 M
On Sat, 2005-03-19 at 18:36 +0100, [EMAIL PROTECTED] wrote:
> 2. I've create a table based on from the master. I copied a fraction from
> the master into the new table using a where clause (insert into ... select
> * from ... where a = b . The number of records copied is about 2553.
>
> Issueing
Hi There,
I've a problem with inserting data and I can't figure out what the problem
is:
what did I do:
1. I've a master table containing about 4 records. A count(*) provides
me the exact number.
2. I've create a table based on from the master. I copied a fraction from
the master into the
