Thanks to answer me.
You was very kindly to write me a so nice text. :-)
E.F.:> The "best book" for you really depends on what you are after!
E.F.:>
E.F.:> Are you interested in a book which is easy to read, gives good
E.F.:> foundational concepts, and gives you decent skills with
E.F.:> Postgr
E.F.:>
E.F.:> Hi,
E.F.:>
E.F.:> Well depends what are you looking for.
E.F.:>
E.F.:> I am using a lot PostgreSQL: Introduction and Concepts
E.F.:> by Bruce Momjian.
E.F.:> Then I have bought "PHP and PostgreSQL Advanced Web
E.F.:> Programming" by
E.F.:> Ewald Geschwinde and Hans-Juergen Sc
Bom dia Roberto!
I have just read these documents.
The variables listed in the link below, say about variable that I
cannot
set from a .profile file.
By the way, if I wat to state that all NUMERIC values must follow a
format
as ###,###.##& these docs do not say how to do t
>
> Ok, this was a test. I'd like to know what would be happen.
> But, from you, great PostGres DBA's, what is the best way to
> insert a large number of data?
> Is there a way to turn off the log?
> Is there a way to commit each 100 records?
Yes, "COPY" actually d
In article <3D42D7AA.27447.3EE190A0@localhost>, "Dan Langille" wrote:
> This is an extension of the problem solved by
> http://archives.postgresql.org/pgsql-sql/2002-03/msg00020.php but
> with a slightly different complication.
>
> I want to get the last 100 port commits from the database. Com
Did you know that you can probably change your GROUP BY clause to use a
column ref, rather than repeating the CASE statement:
GROUP BY gmmid, gmmname, divid, divname, feddept, deptname, fedvend,
vendor_name, masterid, master_desc, pageid, oz_description, 13,
price_original, price_owned_retail,
Hi,
I wonder if I can alter the type of a column to a "supertype" of the
original column type? Afaik, this was impossible in 7.1.3. However, I
use 7.2.1. If yes, what would be the correct syntax?
Cheers,
Thiemo
--
Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur
http://jermt.sourceforge
On Mon, Jul 29, 2002 at 08:57:12AM -0300, Elielson Fontanezi wrote:
> Bom dia Roberto!
Bom Dia! :-)
> I have just read these documents.
> The variables listed in the link below, say about variable that I
> cannot
> set from a .profile file.
> By the way, if I wat to state that
Hi,
I am using postgresql 7.2.1.
I badly require to interconnect between databases. contrib/dblink seems to
be handy and ofcourse it well suits my requirement. But while browsing
across, i heard that it is not advicable to use it. So i wish to know
someone's experience in using dblink and how han
All,
I have two tables t_proj, t_task see below:
CREATE TABLE t_proj (
proj_id SERIAL NOT NULL,
PRIMARY KEY (proj_id),
task_id integer(12),
user_id integer(6),
title varchar(35),
description varchar(80)
);
CREATE TABLE t_task (
task_id SERIAL NOT NULL,
PRIMARY KEY (task_id),
title varchar(35),
Thank you for explaining that in detail it makes sense now. I'll give it a
try.
Thanks again!
-p
-Original Message-
From: Ken Corey [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 1:05 PM
To: Peter Atkins
Cc: '[EMAIL PROTECTED]'
Subject: RE: Returning PK of first insert for second
Gunther Schadow <[EMAIL PROTECTED]> writes:
> A very frequent decision support query we have to make is to get the
> last act of a certain type that occurred before a certain cut-off
> date.
This seems pretty close to the type of problem DISTINCT ON is intended
to solve. Look at the "weather rep
System:
OS: RedHat 7.2
Dual PIII XEON
Mem 512 mg
PG: 7.2
I have what I think is a fairly simple summary query, but it takes 1:55 to
run on just 155k records. The query hits against a single table that I use
for reporting purposes. This table is truncated, refreshed, reindexed, and
vacuum analy
13 matches
Mail list logo
