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
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
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
, 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
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
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,
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
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