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
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
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
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
-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
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
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
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
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
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
10 matches
Mail list logo
