Hi.
Can anybody take me reference on Database design tool with PostgreSQL
support.
thanks.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Tue, Oct 29, 2002 at 23:19:55 +0100,
Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Josh Berkus writes:
>
> > I wrote a MAX(bool), what are the chances it would get added to the core? I
> > don't see any good reason not to have one.
>
> One reason not to have one is that Boolean values are
Hello,
I have a "baseTable". I have a number
of decendantTables that INHERIT from the base table.
I want to do somthing like
=>select * from baseTable;
But I want it to return the data in the all the
descendant tables along with the extra column that they contain. How do I
do thi
Josh Berkus writes:
> I wrote a MAX(bool), what are the chances it would get added to the core? I
> don't see any good reason not to have one.
One reason not to have one is that Boolean values are not naturally
ordered, so a maximum doesn't exist. (Yes, I know there are comparison
operators de
Tom,
> Perhaps
> SELECT true = ANY (SELECT boolcol FROM ...);
> or
> SELECT true IN (SELECT boolcol FROM ...);
>
> Which is not to say that MAX(bool) might not be a nicer solution;
> but you can definitely do it with SQL-spec constructs.
Based on some rough testing,
SELECT true = A
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
NotDashEscaped: You need GnuPG to verify this message
> I'm wondering if anyone has written code that enables you to move
> entities between parents in a nested set model. Specifically something
> that can do it without deleting any of the children i
On 29 Oct 2002, Philip Van Hoof wrote:
> Note that I have searched A LOT on google about this subject and I do
> know that this probably is a FAQ. But I also have not yet found any
> answer that we can actually use :). We have no problem with using beta
> versions. There is one requirement with b
Josh Berkus <[EMAIL PROTECTED]> writes:
> Odd question: I have a query that returns a set of none to several rows. One
> column in these rows is BOOLEAN. I want the query to return:
> 1) TRUE if *any* of the BOOLEAN values is TRUE;
> 2) FALSE if *all* of the BOOLEAN values are FALSE;
> 3) FALSE
Hi there,
We are developing a large application which uses up to 500 Stored
Procedures. Because we need a good but cheap database for when we sell
our application to customers we decided to try porting our applications
Database Management System to PostgreSQL.
Our application is writting in .N
I really do need to develop some people skills.
At least enough to avoid the ego bruises.
CoreReader is a free download at
http://corereader.com
It does point and click queries. It runs from a
windows front end, but is designed to connect to
any data source on any computer.
It has run aga
10 matches
Mail list logo
