O Oleg Bartunov έγραψε στις Jan 26, 2005 :
> Achilleus,
>
> I'm looking for better documentation for contrib/intarray.
> As an experienced user of this module, could you prepare
> tutorial on using the module in real life applications ?
Oleg, i wrote to you, but i suspect my machine is
spam list
On Jan 27, 2005, at 11:10 AM, KÖPFERL Robert wrote:
That's bad.
Is there really no ohter way?
So it takes TWO termoral tables. Or even more?
I'm not sure what is bad. In what sense is it bad? How does more than
one table come into things?
And it can't be just sql because theres more around that
On Thu, 27 Jan 2005 17:11:55 +, Richard Huxton wrote
> > Joel Fradkin wrote:
> >
> > I was told the Xeon processors will do fine up to 64gig. I
> > realize the 64bit chips may be faster, but it is also new
> > and I feel safer with existing technologies and hardware
> > vendors.
> >
> > My un
Joel Fradkin wrote:
I was told the Xeon processors will do fine up to 64gig. I realize the 64bit
chips may be faster, but it is also new and I feel safer with existing
technologies and hardware vendors.
My understanding is that CPU (4 Xeon 3gig processors) will not be a issue,
but hopefully adding
Wilton wrote:
StrCampo = ''new.'' || qCampos.attname;
StrInsert = StrInsert || virgula || StrCampo || '' - '';
End Loop;
Return new;
End;
What i need to do for the variable StrCampo returns to me "SP", "RJ", i
mean, return a value inserted into the field.
I do not want to use sta
Thanks so much to everyone who jumped in both on a config and now the
hardware side of things.
I did modify my order on the new equipment to include a powervault 220 (just
a bunch of drives)
I added a controller card and 4 10 k drives for data raid 10 and 2 15 k
drives raid 1 for WAL. I will use
Inside a function of trigger type, i have:
Declare
qCampos record;
StrCampo string;
StrInsert string;
Begin
StrCampo = ;
StrInsert = ;
For qCampos in select pga.attname from pg_class pgc, pg_attribute pga
where pgc.relname = || tg_relname || and
That's bad.
Is there really no ohter way?
So it takes TWO termoral tables. Or even more?
And it can't be just sql because theres more around that statement.
> -Original Message-
> From: Sean Davis [mailto:[EMAIL PROTECTED]
> Sent: Donnerstag, 27. Jänner 2005 14:57
> To: KÖPFERL Robert
> C
Sandeep,
Using pl/perl at least, you could probably do this. My guess is that
pl/python (and perhaps pl/R) would offer similar functionality. At
least for pl/perl, I think you would need to use the untrusted version
and use a module like LWP. I haven't tried this, but I think it should
be po
Wilton <[EMAIL PROTECTED]> writes:
> I have a table "customers", then a user go there and change the customer
> record, for example he changes the zip code column. Then I can know that
> something changed into the "customer table", and send a full update of
> that record through the web to the d
Subject: RE: [SQL] same question little different test MSSQL vrs Postgres
Now you tell me.
We had a fellow working here kept screaming AMD, but I am a very paranoid
person and was not aware Linux and Postgres have been running on the new
chips. I don't like to be a first. We have bought the Dell
Hi,
I am using Postgres 7.3.4. I want to write a trigger for
insert, update, delete operation on say, user table. This trigger will
activate an URL. URL will be as:
http://sandeep/Trigger?userid=4&name=sandeep where, userid and password
will be parameters to send. They may taken from
Now you tell me.
We had a fellow working here kept screaming AMD, but I am a very paranoid
person and was not aware Linux and Postgres have been running on the new
chips. I don't like to be a first. We have bought the Dell and I cant tell
you if the controller uses 64bits, I just got what they had
On Thu, 27 Jan 2005 18:47:44 +0530, Sandeep Gaikwad
<[EMAIL PROTECTED]> wrote:
> Hi,
> I am using postgres 7.3.4. I am new to postgres.
> I can give foreign key relationship between two tables of same
> database. Can I give foreign key relationship between tables of two databases
See this section of the manual:
http://www.postgresql.org/docs/8.0/interactive/plpgsql-control-
structures.html
In particular, look at 35.7.1.2 and 35.7.4. I think you need to loop
through the results of the query in order to return them. If you just
want to return the result set as a whole
On Thu, 27 Jan 2005, Sandeep Gaikwad wrote:
> I can give foreign key relationship between two tables of same
> database. Can I give foreign key relationship between tables of two
> databases ? Plz, let me know if possible & send me how can I do that?
Unfortunately, that's not really current
Hi,
I am using postgres 7.3.4. I am new to postgres.
I can give foreign key relationship between two tables of same database. Can I give foreign key relationship between tables of two databases ? Plz, let me know if possible & send me how can I do that?
Thanks & Regards,
Sandeep.
--
Sorry
if i´m sendind this question to the wrong place... it´s because i´m new
here and i didn´t found the place in the web to send my question over
the same that i already did.
But let´s see if you can help me. The situation is like this.
I have a
table "customers", then a user go there and
Hi,
I'm trying to find an equivalent plpgsql function as this:
func x returns SETOF "Tablename" AS
'
Select * from "Tablename";
' language sql
How is this accomplished with plpgsql while not using a loop or a second and
third temporal table?
---(end of broadcast)
On Thu, 27 Jan 2005 13:44:32 +0200, Andrei Bintintan <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have a table:
> CREATE TABLE werke1(
> id SERIAL,
> id_hr int4 NOT NULL,
> id_wk int4 NOT NULL
> );
>
> CREATE TABLE contact(
> id SERIAL,
> type varchar(20),
> );
>
>
> Now id_hr and id_wk are all referen
Wilton wrote:
Hi...
People, i wanna know how can i know inside of a function whar the
trigger called, i mean which instruction SQL it called.
I do not wanna know if it´s a insert, update or delete (tp_op), i need
to know the complete instruction.
For example, i need to know something like this:
On Jan 27, 2005, at 6:44 AM, Andrei Bintintan wrote:
Hi,
I have a table:
CREATE TABLE werke1(
id SERIAL,
id_hr int4 NOT NULL,
id_wk int4 NOT NULL
);
CREATE TABLE contact(
id SERIAL,
type varchar(20),
);
It looks like you want a two-column primary key for table contact and
then you can refere
Hi,
I have a table:CREATE TABLE werke1(id SERIAL,id_hr int4 NOT NULL,id_wk int4 NOT NULL);
CREATE TABLE contact(id SERIAL,type
varchar(20),
);
Now id_hr and id_wk are all referencing the same
table contact(id). In the contact table I have another column called type.
How can I write
Hi...
People, i wanna know how can i know inside of a function whar the
trigger called, i mean which instruction SQL it called.
I do not wanna know if it´s a insert, update or delete (tp_op), i need
to know the complete instruction.
For example, i need to know something like this:
update phones
24 matches
Mail list logo
