Re: [HACKERS] We are not following the spec for HAVING without GROUP BY

2005-03-10 Thread johnnnnnn
On Thu, Mar 10, 2005 at 12:44:50PM -0500, Tom Lane wrote: Would those of you with access to other DBMSes try this: DB2/LINUX 8.1.6 create table tab (col integer); select 1 from tab having 1=0; 1 --- 0 record(s) selected. select 1 from tab having 1=1; 1

Re: [HACKERS] PostgreSQL vs. MySQL

2003-07-04 Thread johnnnnnn
On Fri, Jul 04, 2003 at 10:49:01AM -0400, Rod Taylor wrote: In my opinion the defaults should be set up for a typical database server machine. Ok.. thats fair. The first problem would be to define typical for current PostgreSQL installations, and typical for non-postgresql installations

Re: [HACKERS] [GENERAL] Physical Database Configuration

2003-06-25 Thread johnnnnnn
On Wed, Jun 25, 2003 at 11:34:14AM -0400, Tom Lane wrote: Has anyone looked at the syntaxes used by other databases to control tablespaces (Oracle, DB2, etc)? I have no strong desire to slavishly follow Oracle, but it would be a shame to miss out on any good ideas. DB2: CREATE TABLESPACE

Re: [HACKERS] [GENERAL] Physical Database Configuration

2003-06-25 Thread johnnnnnn
, but with the ability to put indices explicitly into a tablespace. -johnn ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] Upgrading the backend's error-message infrastructure

2003-03-14 Thread johnnnnnn
On Thu, Mar 13, 2003 at 03:51:00PM -0500, Tom Lane wrote: Wire-protocol changes - Error and Notice (maybe also Notify?) msgs will have this structure: E x string \0 x string \0 x string \0 \0 where the x's are single-character field

Re: [HACKERS] Upgrading the backend's error-message infrastructure

2003-03-14 Thread johnnnnnn
On Fri, Mar 14, 2003 at 12:23:04PM -0500, Tom Lane wrote: It would seem to make more sense to me to provide a different function(s) which allows the lookup Messages, Details, and Hints based on the SQLSTATE. This would constrain us to have a different SQLSTATE for every error message,

Re: [HACKERS] SQL99 ARRAY support proposal

2003-03-13 Thread johnnnnnn
On Thu, Mar 13, 2003 at 09:53:15AM -0800, Joe Conway wrote: implode(text[], text) returns text - join array elements into a string using given string delimiter I'm open to opinions on implode() -- I only picked implode() because that's what it is called in PHP. Any suggestions? In both Perl

Re: [GENERAL] [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-07 Thread johnnnnnn
On Tue, Jan 07, 2003 at 03:10:06PM -0800, Dann Corbit wrote: NOTICE: QUERY PLAN: SetOp Except (cost=202028537.97..202120623.90 rows=1227812 width=24) - Sort (cost=202028537.97..202028537.97 rows=12278124 width=24) - Append (cost=1.00..200225099.24 rows=12278124