Uz.ytkownik James Adams napisa?:
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
As far as I know functions can not return recordsets. Try functions returning cursors
(then FETCH ALL IN..), or temporary tables.
regards Joseph
- Original Message -
From: Philip Van Hoof [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 29, 2002 7:23
Can anybody take me reference on Database design tool with PostgreSQL
support.
visit, http://sourceforge.net/projects/phppgadmin/
regards,
bhuvaneswaran
---(end of broadcast)---
TIP 6: Have you searched our list archives?
From: Stephan Szabo [EMAIL PROTECTED]
To: Philip Van Hoof [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [SQL] Creating Stored Procedures
Date: 29 Oct 2002 10:36:17 -0800
On 29 Oct 2002, Philip Van Hoof wrote:
Note that I have searched A LOT on google about
Yea it would be easier to have everything in one table filling unused with
nulls, but I was trying to avoid that because of the wasted space.
But I think I'll do it that way after all :~]
Thanks for your help
- Original Message -
From: Tomasz Myrta [EMAIL PROTECTED]
To: James Adams
Uz.ytkownik Viacheslav N Tararin napisa?:
Hi.
Can anybody take me reference on Database design tool with PostgreSQL
support.
pgadmin.postgresql.org
Tomasz Myrta
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I installed 7.3beta3 but how do I do it now?
How do I make a function that returns a dataset
Greets
Zertox
He is an email I received from Joe Conway on the subject a month or so ago
Adam Witney wrote:
There have been a few emails recently concerning using functions. However I
am a
On Wed, 2002-10-30 at 07:45, Viacheslav N Tararin wrote:
Hi,
(which list should this go to? I guess it is OT on both...)
Can anybody take me reference on Database design tool with PostgreSQL
support.
Dia and dia2sql (or something similar...) Google knows more :-)
HTH
Johannes Lochmann
Why not simply:
SELECT COALESCE( (SELECT true FROM ... WHERE boolcol LIMIT 1), FALSE);
JLL
Josh Berkus wrote:
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
Of course, I meant
SELECT COALESCE( (SELECT true FROM ... WHERE ... AND boolcol LIMIT 1),
FALSE);
Jean-Luc Lachance wrote:
Why not simply:
SELECT COALESCE( (SELECT true FROM ... WHERE boolcol LIMIT 1), FALSE);
JLL
Josh Berkus wrote:
Tom,
Perhaps
SELECT true = ANY
When doing database work over the web, especially when many records are
on one page, *many* updates get posted to pg that do not change the
record. Eg, the page may contain 50 records, the user changes 1, and
submits.
I assume that a no-change update takes the same resources as a real
update,
One strategy is to use some sort of middleware that takes care of this. On
a project I did a few years ago, I used a perl module that read the record
from Postgres and made it into a perl object. The object contained a
variable, changed, that reflected whether anything had actually changed
in the
How do I get rid of the messages like NOTICE: CREATE TABLE / PRIMARY
KEY will create implicit index 'test_pkey' for table 'test' coming out
from stderr when I run psql with my create table script?
(I don't want to direct them to /dev/null, since I still want to be able
to see the *real* sql
My colleague installed a redhat database 2(which is based on postgresql)
onto his redhat 7.3 machine and it came with a very nice java query
analyzer tool. It is sort of like the query analyzer in MS SQL Server
with the graphical output of the execution plan, quite intuitive.
I wonder if I can
Wei,
My colleague installed a redhat database 2(which is based on postgresql)
onto his redhat 7.3 machine and it came with a very nice java query
analyzer tool. It is sort of like the query analyzer in MS SQL Server
with the graphical output of the execution plan, quite intuitive.
I wonder
Wei,
Do you have any idea of what the software is called? I could only find
the redhat database ISO for download.
Announced on PGSQL-ANNOUNCE a couple of weeks ago:
(if you're not subscribed to PGSQL-ANNOUNCE, you should be)
===
The Red Hat
I use a window client to conncet to a postgreSQL server with windows ODBC.
It seems if I haven't done anything on the connection for hours, the
connection will be dropped. Is that possible to set the time limit of a
connection? Thank you in advance!
Jack
---(end of
17 matches
Mail list logo