pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [pgadmin-support] pgadtransport Procedural and Function from MS SQL Enterprise Manage to PostgreSQL
2+ messages / 2 participants
[nested] [flat]
* Re: [pgadmin-support] pgadtransport Procedural and Function from MS SQL Enterprise Manage to PostgreSQL
@ 2002-09-17 09:07 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 1 reply; 2+ messages in thread
From: Dave Page @ 2002-09-17 09:07 UTC (permalink / raw)
To: XIE, Rong <rong.xie@stud.tu-muenchen.de>; pgsql-docs; +Cc: pgadmin-support@postgresql.org; pgadmin-hackers <pgadmin-hackers@postgresql.org>
You will have to port your functions and procedures manually I'm afraid.
Regards, Dave.
-----Original Message-----
From: XIE, Rong [mailto:rong.xie@stud.tu-muenchen.de]
Sent: 17 September 2002 09:59
To: pgsql-docs@postgresql.org
Subject: [pgadmin-support] transport Procedural and Function from MS SQL Enterprise Manage to PostgreSQL
hallo,
I have PostgreSQL in Linux. I use it with pgAdminII in Wondows2000.
how can I transport Procedural and Function from MS SQL Enterprise Manage to
PostgreSQL.
Thanks!!!
rong
CREATE FUNCTION dbo.getICNroh (@Bogen_Nr smallint)
RETURNS smallint AS
BEGIN
DECLARE @myRet int
--Rohwert der Skala 1 (ICN) ermitteln
DECLARE @step01a smallint
DECLARE @step02a smallint
DECLARE @step01b smallint
DECLARE @step02b smallint
SELECT @step01a = Antwort FROM PAI_ANTWORTEN WHERE ITEM_NR = 75 AND
Bogen_Nr = @Bogen_Nr
SELECT @step01b = Antwort FROM PAI_ANTWORTEN WHERE ITEM_NR = 115 AND
Bogen_Nr = @Bogen_Nr
SELECT @step02a = Antwort FROM PAI_ANTWORTEN WHERE ITEM_NR = 4 AND
Bogen_Nr = @Bogen_Nr
SELECT @step02b = Antwort FROM PAI_ANTWORTEN WHERE ITEM_NR = 44 AND
Bogen_Nr = @Bogen_Nr
SELECT @myRet = ABS(@Step01a - @step01b)
+ ABS(@Step02a - @step02b)
--Wert zurückgeben
RETURN @myRet
END
CREATE PROCEDURE sp_PAI_Werte
@Bogen_Nr int
AS
create table #tmpPAI_Rohwerte (Skala_Nr smallint primary key, Rohwert
smallint)
--Rohwerte ermitteln (außer Skala 1 ICN)
INSERT into #tmpPAI_Rohwerte
SELECT dbo.PAI_SKALEN.Skala_Nr, sum((CONVERT(tinyint,
dbo.PAI_ANTWORTEN.Antwort) + dbo.PAI_KEYcalc.toAdd) *
dbo.PAI_KEYcalc.Faktor) AS Rohwert
FROM dbo.PAI_SKALEN INNER JOIN
dbo.PAI_ITEMinSKALA ON dbo.PAI_SKALEN.Skala_Nr =
dbo.PAI_ITEMinSKALA.Skala_Nr INNER JOIN
dbo.PAI_ITEMS ON dbo.PAI_ITEMinSKALA.Item_Nr =
dbo.PAI_ITEMS.Item_Nr INNER JOIN
dbo.PAI_ANTWORTEN ON dbo.PAI_ITEMS.Item_Nr =
dbo.PAI_ANTWORTEN.Item_Nr INNER JOIN
dbo.PAI_KEYcalc ON dbo.PAI_ITEMinSKALA.keyDir =
dbo.PAI_KEYcalc.keyDir
WHERE (dbo.PAI_ANTWORTEN.Antwort <> ' ') and PAI_Antworten.Bogen_Nr =
@Bogen_Nr
GROUP BY dbo.PAI_SKALEN.Skala_Nr
--ICN Rohwert einfügen
IF EXISTS(SELECT * from #tmpPAI_Rohwerte WHERE Skala_Nr = 1)
UPDATE #tmpPAI_Rohwerte SET Rohwert = dbo.getICNroh(@Bogen_Nr) WHERE
Skala_Nr = 1
ELSE
INSERT INTO #tmpPAI_Rohwerte (Skala_Nr, Rohwert)
VALUES(1,dbo.getICNroh(@Bogen_Nr))
--T-Werte bereitstellen
SELECT dbo.PAI_SKALEN.Skala_Nr, dbo.PAI_SKALEN.Kuerzel_D AS Kuerzel,
dbo.PAI_SKALEN.Label_D AS Label, #tmpPAI_Rohwerte.rohwert as rohwert,
ROUND(50 + (#tmpPAI_Rohwerte.rohwert -
dbo.PAI_SKALEN.M) *10 / dbo.PAI_SKALEN.SD, 0) AS TWert
FROM dbo.PAI_SKALEN LEFT OUTER JOIN
#tmpPAI_Rohwerte ON dbo.PAI_SKALEN.Skala_Nr =
#tmpPAI_Rohwerte.skala_nr
GO
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [pgadmin-support] pgadtransport Procedural and Function from MS SQL Enterprise Manage to PostgreSQL
@ 2003-03-28 12:16 rx <rong.xie@stud.tu-muenchen.de>
parent: Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 2+ messages in thread
From: rx @ 2003-03-28 12:16 UTC (permalink / raw)
To: Dave Page <dpage@vale-housing.co.uk>; pgsql-docs; +Cc: pgadmin-support@postgresql.org; pgadmin-hackers <pgadmin-hackers@postgresql.org>
Messagehallo,
my Name is Rong. I am student at TU-Munich. I have some questions for
Postgresql under SuSe Linux.
I want save something in Postgresql-Table, when I get a fax from "Hylafax".
I insert "
psql -U postgres dbname <<END_OF_INSTR
insert into "CSID_TIF"("CSID","suspens_file","actDatum")
values('0049891234567','test.tif','01.01.2003'))
END_OF_INSTR "
in shell script.
It work very good.
Now I want enhance it.
When there are some error in Postgresql, or There are some Error at insert,
I want give a message per email to me.
But I do not know, how can I get the Error from Postgresql in Linux Shell
Script.
When an Postgresql-Error is to happen, how can I get the Error-Message-Event
in shell script and send a email to me.
I hope I can get your Help!
Thank you very much!
best regards!
rong
PS: faxrcvd is my shell-script in Hylafax.
#! /bin/sh
psql -U postgres dbname <<END_OF_INSTR
insert into "CSID_TIF"("CSID","suspens_file","actDatum")
values('0049891234567','test.tif','01.01.2003'))
END_OF_INSTR
##end script
----- Original Message -----
From: <pgsql-general-owner@postgresql.org>
To: "rx" <rong.xie@stud.tu-muenchen.de>
Sent: Thursday, March 27, 2003 4:03 PM
Subject: Stalled post to pgsql-general
> Your message to pgsql-general has been delayed, and requires the approval
> of the moderators, for the following reason(s):
>
> Non-Member Submission from "rx" <rong.xie@stud.tu-muenchen.de>
>
> If you do not wish the message to be posted, or have other concerns,
> please send a message to the list owners at the following address:
> pgsql-general-owner@postgresql.org
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-03-28 12:16 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-09-17 09:07 Re: [pgadmin-support] pgadtransport Procedural and Function from MS SQL Enterprise Manage to PostgreSQL Dave Page <dpage@vale-housing.co.uk>
2003-03-28 12:16 ` rx <rong.xie@stud.tu-muenchen.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox