Re: [GENERAL] sql formatter/beautifier

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

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

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 R

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

2006-06-09 Thread Aaron Bingham
of these but you have to be careful 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 Bing

[GENERAL] Meaning of "loops" in EXPLAIN ANALYSE output

2006-04-10 Thread Aaron Bingham
is causing the execution time to balloon. Thanks, -- -------- Aaron Bingham Senior Software Engineer Cenix BioScience GmbH ---(e

Re: [GENERAL] how to document database

2006-04-10 Thread Aaron Bingham
with the 'comment 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

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'); >&

[GENERAL] Strange interaction of union and expressions

2005-04-20 Thread Aaron Bingham
; "woof" (2 rows) Is this a known issue? Has it been fixed? Thanks, -- ---- Aaron Bingham Software Engineer Cenix BioScience GmbH ---(end of broadcast)---

Re: [GENERAL] Duplicate counting

2005-01-20 Thread Aaron Bingham
nt_price(retail, discount) AS price, tax FROM foo) AS bar; -- -------- Aaron Bingham Application Developer Cenix BioScience GmbH ---(end of bro