Betr: Re: Betr: Re: [GENERAL] Question insert data

2005-03-20 Thread perico
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 >>

Re: Betr: Re: [GENERAL] Question insert data

2005-03-20 Thread Stephan Szabo
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

Betr: Re: [GENERAL] Question insert data

2005-03-20 Thread perico
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? >-- Oorspronkelijk bericht -- >Date: Sat, 19 Mar 2005 14:55:50 -0800 (PST) >From: Stephan Szabo <[EMAIL PROTECTED]> >To: [EMAIL PROT

Betr: Re: [GENERAL] Question insert data

2005-03-19 Thread perico
Some more info select count(*) from master_bart where substr(locode_c5,1,2) = 'NL' gives me the result: 5106 delete from masterplts_nl; insert into masterplts_nl select * from master_bart where substr(locode_c5,1,2) = 'NL'; Query returned successfully: 2553 rows affected, 5127 ms execution

Betr: Re: [GENERAL] Question insert data

2005-03-19 Thread perico
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 Mar 2005 17:56:52 + > > >On Sat,