[BUGS] how to copy data from excel spreadsheet to postgresql database

2000-09-28 Thread pgsql-bugs
Martin Kuria ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description how to copy data from excel spreadsheet to postgresql database Long Description I have enter data in excel spreadsheet, and I would like to enter or copy this data in

Re: [BUGS] psql wraps lines at 256 characters

2000-09-28 Thread Peter Eisentraut
> the v7.0 psql wraps output lines at 256 characters. The 6.5 version did not. I >sometimes create huge xterms so I can get the output of a select all on one line per >row,and keep the display nicely formatted, but now I just get a big void of emptyness >on the right 3rd of my xterm, because p

[BUGS] Inexplicably running wild and freezing with 7.0

2000-09-28 Thread pgsql-bugs
Julian Coutts ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Inexplicably running wild and freezing with 7.0 Long Description Running on a HP lpr 192RAM 600mz pIII computer. Running 7.0 (have been a big fan of 6.5.3 which was/

[BUGS] very poorly optimised query

2000-09-28 Thread pgsql-bugs
Orion Henry ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description very poorly optimised query Long Description This is for Postgres 7.0.1 running on x86 linux While usually impressed with postgres's speed I ran into a query that ran

[BUGS] Subselects lack functionality

2000-09-28 Thread pgsql-bugs
Kuba Ober ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Subselects lack functionality Long Description 1. Subselects don't allow one to use tuple set operators like UNION, INTERSECT, EXCEPT. It forces one to select the resul

Re: [BUGS] Subselects lack functionality

2000-09-28 Thread Lamar Owen
[EMAIL PROTECTED] wrote: > 2. > It would be gr8 if single column subselects would allow themselves to be treated the >same way as lists do as right-side arguments of IN operator. > This would allow e.g. much more powerful DELETE statement, like > DELETE FROM table WHERE id IN (SELECT ...) This,

Re: [BUGS] Subselects lack functionality

2000-09-28 Thread Tom Lane
[EMAIL PROTECTED] writes: > Subselects don't allow one to use tuple set operators like UNION, > INTERSECT, EXCEPT. Yeah, we know. The existing implementation of UNION etc. is a horrid kluge that only works at the top level of a SELECT (and not even very well there). Fixing this will require a r

[BUGS] /contrib/soundex doesn't work. Version 7.0.2

2000-09-28 Thread pgsql-bugs
Edmar Wiggers ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description /contrib/soundex doesn't work. Version 7.0.2 Long Description The code in /contrib/soundex doesn't work. It does compile though. I create the function in the databa