Re: [GENERAL] sql formatter/beautifier

2007-03-08 Thread Aaron Bingham
beautifier? I wasn't able to find a reference to this feature in the documentation. Thanks, -- Aaron Bingham Senior Software Engineer Cenix BioScience GmbH

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully implementing

2006-06-12 Thread Aaron Bingham
David Fetter wrote: On Fri, Jun 09, 2006 at 03:55:04PM +0200, Aaron Bingham wrote: [EMAIL PROTECTED] wrote: I'm reading, and enjoying immensely, Fabial Pascal's book Practical Issues in Database Management. If you're interested in the theory of RDBMSs, you can start

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully implementing

2006-06-12 Thread Aaron Bingham
Aaron Bingham wrote: David Fetter wrote: In SQL, you can do this (this example condensed from Libkin's Expressive Power of SQL on the page above): SELECT (SELECT count(*) FROM table_1) (SELECT count(*) FROM table_2) AS Can't compare cardinalities in first order logic; Note

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully implementing

2006-06-09 Thread Aaron Bingham
to avoid them, and sometimes you can't). One feature of RM PostgreSQL lacks are nested relations (a bad idea for base table design but useful in query results). Regards, -- Aaron Bingham Senior Software Engineer Cenix BioScience

Re: [GENERAL] how to document database

2006-04-10 Thread Aaron Bingham
on' statement. It can also generate graphical representations of your schema using various tools, including Graphviz. Regards, -- Aaron Bingham Senior Software Engineer Cenix BioScience GmbH Tatzberg 47 phone: +49 (351

[GENERAL] Meaning of loops in EXPLAIN ANALYSE output

2006-04-10 Thread Aaron Bingham
the execution time to balloon. Thanks, -- Aaron Bingham Senior Software Engineer Cenix BioScience GmbH ---(end of broadcast

[GENERAL] Strange interaction of union and expressions

2005-04-20 Thread Aaron Bingham
, -- Aaron Bingham Software Engineer Cenix BioScience GmbH ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan

Re: [GENERAL] Strange interaction of union and expressions

2005-04-20 Thread Aaron Bingham
Kevin Murphy [EMAIL PROTECTED] writes: On Apr 20, 2005, at 1:24 PM, Aaron Bingham wrote: create table a (foo varchar); insert into a (foo) values ('baz'); create table b (foo varchar); insert into b (foo) values ('woof'); select '' || foo || '' as foo from (select foo from a) as bar

Re: [GENERAL] Duplicate counting

2005-01-20 Thread Aaron Bingham
foo) AS bar; -- Aaron Bingham Application Developer Cenix BioScience GmbH ---(end of broadcast)--- TIP 4: Don't