One change you might want to look at is not using the now() function.
According to the docs, the now() function always returns the start of the
transaction time. So, if your code is using transaction blocks, the time may
not be what you are expecting.
This is what I had do to in my trigger to get
Just curious, what is wrong with the first way of coding the solution?
--( Forwarded letter 1 follows )-
Date: Fri, 8 Oct 2004 08:44:23 +0400
To: Thomas.F.O'[EMAIL PROTECTED], [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Sender: [EMAIL PROTECTE
[EMAIL PROTECTED]
Subject: Re: [SQL] raise is not working
"CHRIS HOOVER" <[EMAIL PROTECTED]> writes:
> Sorry for the delay, here is the function.
> CREATE OR REPLACE FUNCTION "public"."clmhdr_grid_query" (varchar, varchar,
> varchar, varchar, varchar
Sorry for the delay, here is the function.
Chris
--
CREATE OR REPLACE FUNCTION "public"."clmhdr_grid_query" (varchar, varchar,
varchar, varchar, varchar, varchar) RETURNS SETOF "public"."clmhdr" AS'
Declare
Last_Name varchar;
First_Name varchar;
Patient_Control_Number varchar;
Cl
Hello again everyone.
I need some help once again. I am following the postgresql pl/pgsql docs and
trying to have my function show me the query it is trying to run since it not
returning the expected results. However, it does not appear that the raise
option is working. Can anyone please point
EMAIL PROTECTED]
Subject: Re: [SQL] Help with function
On Mon, 20 Sep 2004, CHRIS HOOVER wrote:
> I need some help writing a simple function.
>
> Due to some program limitations for a program I run the db's for, I'm having
> to write some simple functions to run some selec
I need some help writing a simple function.
Due to some program limitations for a program I run the db's for, I'm having
to write some simple functions to run some selects. However, I am not sure
how to have them correctly return the record(s) selected and/or how to
properly call them from sql.
