Re: [GENERAL] Assigning Values to Arrays

2003-10-07 Thread Oliver Elphick
On Wed, 2003-10-08 at 11:41, Zitan Broth wrote: > Greetings All, > > Running pg 7.3.4 and was reading: > http://archives.postgresql.org/pgsql-interfaces/2003-09/msg00018.php . Basically > want to assign values to an array and then a 2d array. > > However I can't get this to run in properly I

Re: [GENERAL] Call for Speakers / Presenters

2003-10-07 Thread Joshua D. Drake
As your new PostgreSQL "Master of Ceremonies", What? Master of Ceremonies is a new position that was created by the core (at least Josh Berkus) for dealing with speakers. There are others, such as Editor-n-chief which is myself, and I am in charge of soliciting writers and working with publi

Re: [GENERAL] "select count(*) from contacts" is too slow!

2003-10-07 Thread nolan
> MySQL can tell you from it's index because it doesn't care if it gives you the > right number or not. Under what circumstances would MySQL give the wrong number? -- Mike Nolan ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [GENERAL] concenation of strings and null values

2003-10-07 Thread Tom Lane
Tino Wildenhain <[EMAIL PROTECTED]> writes: > Can someone enlighten me if this is > in accordance to some not so transparent > rules of SQL92 or '99 and if so, how > to work around this? It is per spec: in SQL92 6.13 : 2) If is specified, then let S1 and S2 be the re- sult o

Re: [GENERAL] using copy to load odd characters

2003-10-07 Thread Peter Eisentraut
Johnson, Shaunn writes: > I'm trying to load data from a text file that > has an odd character in it (^@). From what I > could tell, it's a NULL character. How can I > load that into the database via the command line? Depends on what data type the column is supposed to have. Character data typ

[GENERAL] Data partitioning?

2003-10-07 Thread psql-mail
hi, I am becoming more and more convinced that in order to achieve the required performance and scalability I need to split my data amoungst many backend machines. Ideally I would start with about 10 machine and have 1/10th of the data on each. As the data set grows I would then buy additional

[GENERAL] using copy to load odd characters

2003-10-07 Thread Johnson, Shaunn
Title: using copy to load odd characters Howdy: Running PostgreSQL 7.3.3 on RedHat Linux 7.2 I'm trying to load data from a text file that has an odd character in it (^@).  From what I could tell, it's a NULL character.  How can I load that into the database via the command line? I've do

Re: [GENERAL] PostgreSQL Beta4 Tag'd and Bundle'd ...

2003-10-07 Thread Shridhar Daithankar
Robert Treat wrote: Or sign up for -announce and read the weekly news, which gives a summary of each weeks developments* and updates some other ancillary information about the project. That reminds me. There used to be postgresql weekly news on linuxtoday. Haven't noticed them for quite a long.

Re: [GENERAL] Server recommendations

2003-10-07 Thread Shridhar Daithankar
Christopher Browne wrote: [EMAIL PROTECTED] (Shridhar Daithankar) writes: And I also configured a system on laclinux.com, just for curiosity. 2x 1.8GHz/4GB/36GBx2 10K RPM SCSI/Adaptec 29320 for $4800/- is damn cheap a system. HP does not even start below $5K for 64 bit systems. What is _most_ i

Re: [GENERAL] COPY COMMAND

2003-10-07 Thread Richard Huxton
On Tuesday 07 October 2003 07:29, Deepa K wrote: > Hi All, > Is it possible to insert n rows with 1 or 2 invalid rows > using copy command. I used it, it rollbacks everything even if 1 row > gets an error. Is their any other way to do it. You need to remove the bad rows. This is IMHO a "Go