What's the best open source GUI for DB administration? (postgres)
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
I'm having trouble figuring out how to select something.
This is the problem:
>From a copy of the CDDB-database i want to select the artist & album that
has on average the longest tracks.
But in the tracks table there is no such field as length, so i have to
calculate it. But when i try to do so
Hi folks,
I have a problem with a CHECK clause that doesn't seem to work properly. The
CREATE TABLE statement looks like this:
CREATE TABLE epilepsy_information (
[...]
epilepsy_class Char
CHECK (epilepsy_class IN ('f', 'g', 'n')),
focusInteg
"Jörg Holetschek" <[EMAIL PROTECTED]> writes:
> CASE
> WHEN ((focus <> NULL) AND (epilepsy_class = 'f')) THEN
> TRUE
Try "focus IS NOT NULL".
regards, tom lane
---(end of broadcast)-
On Thu, Jun 27, 2002 at 11:52:54AM +0200, J?rg Holetschek wrote:
> Hi folks,
>
> I have a problem with a CHECK clause that doesn't seem to work properly. The
> CASE
> WHEN ((focus <> NULL) AND (epilepsy_class = 'f')) THEN
> TRUE
> WHEN
On Wed, 26 Jun 2002 17:34:47 +0200
Alvar Freude <[EMAIL PROTECTED]> wrote:
> Hi,
>
> -- Eric <[EMAIL PROTECTED]> wrote:
>
> > If I perform the following 2 selects, the first one is EXTREMELY slow
> > where the 2nd one is very fast.
>
> [...]
>
> > Why would 2 be so much faster? I have ran
Tom Lane wrote:
> It won't happen. See the many, many prior discussions of this point in
> the archives.
Hmm, I searched the archives both in my local mailbox and on Google,
could you give me some pointer to a relevant thread? I certainly
want to learn from past discussions.
So, it's that MVC
On Thursday 27 Jun 2002 10:52 am, Jörg Holetschek wrote:
> Hi folks,
>
> I have a problem with a CHECK clause that doesn't seem to work properly.
> WHEN ((focus <> NULL) AND (epilepsy_class = 'f')) THEN
> WHEN ((focus <> NULL) AND (epilepsy_class IN ('g',
On Mon, 2002-06-24 at 22:43, Stephan Szabo wrote:
> On 24 Jun 2002, Marcos Garcia wrote:
>
> Hmm, that should only happen if you're doing alot of updates or deletes
> I would guess (updates would cause it to slow down as well since it's
> similar to a delete and insert under MVCC). And frequent
On Wed, 26 Jun 2002 22:18:07 +0200
Dennis Kaarsemaker <[EMAIL PROTECTED]> wrote:
> From a copy of the CDDB-database i want to select the artist & album that
> has on average the longest tracks.
>
> But in the tracks table there is no such field as length, so i have to
> calculate it. But when i
On 27 Jun 2002, Marcos Garcia wrote:
> On Mon, 2002-06-24 at 22:43, Stephan Szabo wrote:
> > On 24 Jun 2002, Marcos Garcia wrote:
> >
> > Hmm, that should only happen if you're doing alot of updates or deletes
> > I would guess (updates would cause it to slow down as well since it's
> > similar t
On Thu, Jun 27, 2002 at 07:50:09PM +0800, q u a d r a wrote:
>
> What's the best open source GUI for DB administration? (postgres)
Emacs. ;)
--
Ron Peterson -o)
87 Taylor Street /\\
Granby, MA 01033 _\_v
https://www.yellowbank.com/
-
On Thu, Jun 27, 2002 at 04:24:04PM +0100, Marcos Garcia wrote:
> On Mon, 2002-06-24 at 22:43, Stephan Szabo wrote:
> > On 24 Jun 2002, Marcos Garcia wrote:
> >
> > Hmm, that should only happen if you're doing alot of updates or deletes
> > I would guess (updates would cause it to slow down as wel
Perhaps this was covered in the 7.2.x release notes, but it's mystifying us:
select to_char(time_link,'999.99') from stat_fetch
where time_link is not null
order by 1 desc limit 10;
(time_link is a double-precision column.) Under 7.1.3, this returns results like:
to_char
-
9.99
Can someone please tell me how to unsubscribe from all the pgsql lists?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Masaru Sugawara wrote:
>
> You are right. And this type of optimising are not yet implemented.
> Tom said it in the prior discussions.
>
...but is it true that if you place the filter clause first,
the join will not have to complete the whole table?
eg.
SELECT item.description, stock.avai
> The problem isn't in the select.
>
> I realize that my database is growing and growing.
>
> I've two tables that have, lets say, 120.000 records each, and:
> - delete about 30.000 records a day from each table
> - insert about 30.000 records a day on each table
> - update each record at least
I have a query that returns
?column?
-
6 days 01:56:14
(1 row)
How can I get it as total number of hours?
Instead of days and hours, I need hours only (all in all, so 24hours * 6
days + 01:56:14)
Can you help me please? Thanks
---(end of bro
Keith Gray <[EMAIL PROTECTED]> writes:
> ...but is it true that if you place the filter clause first,
> the join will not have to complete the whole table?
PG's planner does not pay attention to the ordering of WHERE clauses;
it will do what it thinks best with them in any case.
how can i implement transactions inside my plpgsql functions
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Joe,
> how can i implement transactions inside my plpgsql functions
You can't.
Each PL/pgSQL function is automatically treated as a single transaction
by Postgres. As such, the entire function either succeeds or fails.
To manage a transaction *inside* the PL/pgSQL function, Postgres would
h
Le Jeudi 27 Juin 2002 13:50, q u a d r a a écrit :
> What's the best open source GUI for DB administration? (postgres)
Why ? Mine of course !
Noway for this stupid answer !
Well, I would say that you have at least two choices amongst those I know :
phpPgAdmin, which works as it's name says with p
> how can i implement transactions inside my plpgsql functions
I would guess that this is not possible since postgres don't support
nested transactions(?).
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
C
23 matches
Mail list logo
