This could be an old conversation for most. I've used PostgreSQL for a
while but I haven't fully use the Procedure/Functions to it fullest
until now. I need to migrate a MS-SQL 2000 database to PostgreSQL.
I've read as much as I could find but I seem to be missing something.
I did see last week
CH NEXT FROM NewListCursor INTO fname, id;
END;
CLOSE NewListCursor;
$BODY$
LANGUAGE 'sql' VOLATILE;
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr
Sent: Saturday, December 10, 2005 10:41 PM
To: Foster, Stephen
Cc: pgsql-gener
Ok, I tried it in that I'm still getting errors. Happy to do so but
well is my errors?
-Original Message-
From: Douglas McNaught [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 11, 2005 10:39 AM
To: Foster, Stephen
Cc: 'Michael Fuhr'; pgsql-general@postgresql
Trying a totally different approach. Simple procedure that I'm using to
use as learn opportunity in stored procedures in PostgreSQL prior to
migrating a complex web site. Call it a training example if you will.
Goal is to learn the correct process of working with cursors on complex
queries in Pos
Thanks Michael! Guess I should have drunk more coffee before replying.
I must have miss that.
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 11, 2005 11:22 AM
To: Douglas McNaught
Cc: Foster, Stephen; pgsql-general@postgresql.org;
pgsql-sql
I'm having a problem converting a simple date routing to PLPGSQL. I
know the error has to be something stupid but I'm missing it. The error
is in the "ExpireDate := (date 'StartDate' + integer 'NumOfDays');" line
in the procedure below. I didn't understand why I had to convert the
date to a stri
al Message-
From: Michael Glaesemann [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 24, 2006 6:58 PM
To: Foster, Stephen
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Setting expire date on insert/modify
On Jan 25, 2006, at 9:45 , Foster, Stephen wrote:
> ERROR: invalid input synt
ent: Tuesday, January 24, 2006 7:18 PM
To: Foster, Stephen
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Setting expire date on insert/modify
On Tue, 24 Jan 2006, Foster, Stephen wrote:
> CREATE OR REPLACE FUNCTION "TF_BannerAd_Ads_InsMod"()
> RETURNS "trigger&qu
