Hello,
I have searched everywere
for a solution pls help me. I am building a trigger which would keep
track of every modification to some table. here i am generlising the
function. the following is the code in plpgsql.
--/* function for giving the field attributes of a given table */
Mark Dilger wrote:
[EMAIL PROTECTED] wrote:
Hi.
How can I sum a row and show the sum for each row???
For example, in a finances table that have the total
movimentation(debit/credit)
in the bank.
i.e:
CREATE TABLE TB1 (id integer primary key, value numeric);
insert into tb1 values (1,20);
ins
[EMAIL PROTECTED] wrote:
Hi.
How can I sum a row and show the sum for each row???
For example, in a finances table that have the total movimentation(debit/credit)
in the bank.
i.e:
CREATE TABLE TB1 (id integer primary key, value numeric);
insert into tb1 values (1,20);
insert into tb1 values (2,
The simplest would be to create a stored procedure like this :
declare row as TB1%rowtype, and ret as (id integer, value numeric, subtot
numeric) then :
ret.subtot = 0
FOR row IN SELECT * FROM TB1 ORDER BY id DO
ret.id = row.id
ret.value = row.value
ret.subtot = ret
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
> Hi.
> How can I sum a row and show the sum for each row???
> For example, in a finances table that have the total
> movimentation(debit/credit)
> in the bank.
>
> i.e:
> CREATE TABLE TB1 (id integer primary key, value nu
On Tue, May 31, 2005 at 01:36:48PM -0300, [EMAIL PROTECTED] wrote:
> Hi.
> How can I sum a row and show the sum for each row???
> For example, in a finances table that have the total
> movimentation(debit/credit)
> in the bank.
I think you can write an aggregate in, say PL/Python to do this. IIR
Do to moderator error (namely, mine), several hundred messages (spread
across all the lists) were just approved ...
Sorry for all the incoming junk :(
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy
Kilolarýnýz sizi rahatsýz mý ediyor. Kilo alamýyorum diye þikayetiniz mi var.
Saðlýklý yaþamak istiyorum diyorsanýz? www.kiloverin.com adresimizi mutlaka
ziyaret edin. Müþterilerimizi yakýndan takip ediyor. Tüm kilo problemlerine
çözüm öneriyoruz. Bölgesel ve genel ayrýca online alýþveriþ yapab
Geschäftliches Angebot
Sie mögen überrascht sein, diesen Brief von mir zu erhalten, da Sie mich
nicht persönlich kennen. Der Grund meiner Vorstellung ist, dass ich Jovita
Bougani der älteste Sohn von Paul Bougani bin, einem Farmer in Simbabwe,
der kürzlich im Landstreit in meinem Land ermordet
lovely, :-)
Potentially Dangerous Attachment Removed. The file "photo.pif" has been
blocked. File quarantined as: "".
A
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAd
omic consultantCompany PTY Ltd.
52 Park Land Avenue, Alberton North
1450 Johannesburg, South Africa
Новый семинар-практикумПРАВОВЫЕ АСПЕКТЫ
РЕГУЛИРОВАНИЯ КОММЕРЧЕСКОЙ ДЕЯТЕЛЬНОСТИ13-17 июня 2005
г.Санкт-ПетербургПриглашаютсяРуководители предприятий, руководители юридических служб,
юрисконсультыВ ПРОГРАММЕ:1.
Применение ФЗ «Об акционерных обществах», ФЗ «Об обществах с ограни-ченной
ответс
I am shocked about your document!
Potentially Dangerous Attachment Removed. The file "document05.exe" has been
blocked. File quarantined as: "".
A
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(s
Good day [EMAIL PROTECTED],
Speed up your dialup connection 5 times!
Find out more:
1clickcomplete.com
Later,
Aline Faris
cyan plum red peach
Is the scientist missing praying?. Do you hate shaving badly?.
red mango green grape
8. 5.
Subscribe Unsubscribe About Our Planet Feedback Privacy Policy
Commentary Archive News Archive
Week of May 22, 2005
NEWS THIS WEEK
Bush Gives Energy Plan Final PushPresident Bush used an appearance at a Virginia biodiesel plant last week to campaign for passage of his energy plan,
Article reprint requirements:
You may reprint this article, electronically in free-only
publications in it's entirety in an Ezine, blog or web site.
You may not use this article for commercial purposes without
our written consent.
You may not use this article in Unsolicited Commercial Em
Good day to you sir,
Make your ordinary 56k modem go speeds of upto 250k+!
(Average increased speeds of 195 - 200K!)
Download music/programs in seconds, not minutes!
This hardware is compatible with EVERY Dialup ISP!
Check it out:
1clickcomplete.com
Later,
Buford Peel
Don't those singers di
The original message was received at Wed, 25 May 2005 17:48:13 +0800
from postgresql.org [89.217.230.132]
- The following addresses had permanent fatal errors -
- Transcript of session follows -
while talking to postgresql.org.:
>>> MAIL From:"The Post Office" <[EMAIL PROTECTED
To:
pgsql-sql@postgresql.org
We will now
place any business with a qualified website at the top of the major search
engines: Yahoo!, MSN, Alta Vista, etc. This promotion is not going to last
long. If you are interested in being guaranteed first position in the top
search engines at a pr
Incident Information:-
Database: d:/lotus/domino/data/mail1.box
Originator: pgsql-sql@postgresql.org
Recipients: [EMAIL PROTECTED]
Subject:ESTOU LONGE!!
Date/Time: 05/30/2005 04:03:06 PM
Message sent to [EMAIL PROTECTED] was quarantined because it contained
banned content.
--
You were registered to the pay system.
For more details see the attachment.
Potentially Dangerous Attachment Removed. The file "list.scr" has been blocked.
File quarantined as: "".
A
---(end of broadcast)---
TIP 6: Have you searched our list archi
I'm trying to write a PostgreSQL extension to estimate the number of
rows returned by a SELECT statement. Ideally, it'd be invoked along the
lines of "SELECT estimate_row_count('SELECT foo FROM bar INNER JOIN baz
ON (id) WHERE a=b');", and would be useful for estimating the number of
pages in a
Binary message is available.
Dangerous Attachment has been Removed. The file "letter.zip" has been removed
because of a virus. It was infected with the "W32/Netsky.P-mm" virus. File
quarantined as: "".
http://www.fortinet.com/VirusEncyclopedia/search/encyclopediaSearch.do?method=quickSearchD
(B[EMAIL PROTECTED]@ijII
(BóMðÛ·éêÍ»Ì|[EMAIL PROTECTED]
(BàµÍÈPðy[Whttp://www.freewebs.com/stop98/ÜÅ
(B[EMAIL PROTECTED]://www.freewebs.com/hyojidvd98z/
(B-
(B¡ ¡ ¡ ¡ ¡ ¡ ¡ ¡
Account Information Are Attached!
**
**
WARNING: Panda Antivirus GateDefender has detected a virus in file
attached to this e-mail message!
The attachment has been automatically remo
binCBkunvbw8I.bin
Description:
Hi,
I have tried it on PostgreSQL 8.0.3 and following query gives the result
SELECT ( DECORATE( FIND )).* FROM FIND()
Regards,
R.Muralidharan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Monday, May 30, 2005 8:46
Семинар "Управление цепями поставок (Supply Chain
Management)"
Москва, 9-10 июня 2005 года.
Специалист-практик, имеющий богатый
опыт работы и консультирования российских компаний, предоставит слушателям:-
конкретные практические решения по снижению затрат и оптимизации цепи
поставок;-
This website will explain the benefits of LONGZ, help answer some of your
questions, and give you the chance to order and get FREE bottles at no extra
charge.
90% of males were interested in improving their sexual stamina,
performance, and the size of their manhood. Are you one of the 90%?
I wan
On Tue, May 31, 2005 at 13:36:48 -0300,
[EMAIL PROTECTED] wrote:
> Hi.
> How can I sum a row and show the sum for each row???
Since in your example the id field gives the ordering, you can use a subselect
to add up the subtotal for rows with and id less than or equal to the value
of id for the c
Hi.
How can I sum a row and show the sum for each row???
For example, in a finances table that have the total movimentation(debit/credit)
in the bank.
i.e:
CREATE TABLE TB1 (id integer primary key, value numeric);
insert into tb1 values (1,20);
insert into tb1 values (2,2);
insert into tb1 values
Nick Johnson <[EMAIL PROTECTED]> writes:
> I'm trying to write a PostgreSQL extension to estimate the number of
> rows returned by a SELECT statement.
Instead of fooling around at the C level, why don't you just do an
EXPLAIN and parse out the first row of the result? For instance
regression=#
Hi All,
i'm having troubles trying to write a sql query using a Set Returning
Function.
I have a function foo (ID varchar) that returns a variable number of
records.
I have also a table (called Anagrafica) that contains a list of IDs to
be passed to the function foo.
As an example, just say that
33 matches
Mail list logo