[SQL] OFFTOPIC: search and replace with unix tools

2001-05-07 Thread Oliver Seidel
> "Josh" == Josh Berkus <[EMAIL PROTECTED]> writes: Josh> Folks, I need to strip certain columns out of my pgdump Josh> file. However, I can't figure out how to use any Unix-based Josh> tool to search-and-replace a specific value which includes a Josh> tab character (e.g. rep

[SQL] array column -- do you really want this?

2000-09-05 Thread Oliver Seidel
Hello Umashankar, *warning* this doesn't answer the question you asked *warning* you write that you are new to object databases. The problem that you describe sounds like it might much more completely be solved by not using the object features and avoiding an array alltogether. If you simply w

Re: [SQL] Regular expression query

2000-08-28 Thread Oliver Seidel
il Transfer Agent (exim), it is optimised for performance. I hope I have been of help, Oliver Seidel

[SQL] car mileage summation / sledgehammer method

2000-08-16 Thread Oliver Seidel
OK, this is quite brutal and is going to be very expensive, but I think it does what you want. The trick lies in the idea of joining a table with itself. Thus, I first define a virtual copy of the table (in my case "dup") and then produce a query that joins the table to this copy. Enjoy. Oliv