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
> install
"INDEX IN" and "LONG IN" extensions, 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 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
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
> mes
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-chara
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?
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
