On Mon, Feb 23, 2009 at 09:39:01AM -0800, SHARMILA JOTHIRAJAH wrote:
> Hi,
> This is a simple function that returns a boolean ..
This should be an SQL function, as it doesn't do anything you need (or
would even find convenient) for a more procedural language to do:
CREATE OR REPLACE FUNCTION chec
On Mon, Feb 23, 2009 at 9:39 AM, SHARMILA JOTHIRAJAH
wrote:
>IF ( newValue != oldValue)
One good piece of advice that Tom Lane pointed out to me was:
IF ( newValue IS DISTINCT FROM oldValue )
is better due to (what may be) the unexpected results of equality
testing when NULL values are thr
- "SHARMILA JOTHIRAJAH" wrote:
> Hi,
> This is a simple function that returns a boolean ..
>
> create or replace function check_value( newValue IN VARCHAR,
> oldValue IN VARCHAR ) RETURN BOOLEAN
^^ RETURNS
> as
> '
> BEGIN
SHARMILA JOTHIRAJAH writes:
> create or replace function check_value( newValue IN VARCHAR,
> oldValue IN VARCHAR ) RETURN BOOLEAN
Should be RETURNS BOOLEAN.
You might want to fix whatever client code you are using so that it
shows the error cursor, which would certainly have
Its a typo..it should be "RETURNS BOOLEAN" and not "RETURN BOOLEAN"
-Sharmila
--- On Mon, 2/23/09, SHARMILA JOTHIRAJAH wrote:
> From: SHARMILA JOTHIRAJAH
> Subject: Function that returns Boolean
> To: "General postgres mailing list"
> Date: Monday, February 23, 2009, 12:39 PM
> Hi,
> This is
Hi,
This is a simple function that returns a boolean ..
create or replace function check_value( newValue IN VARCHAR,
oldValue IN VARCHAR ) RETURN BOOLEAN
as
'
BEGIN
IF ( newValue != oldValue)
then return true;
else
return false;
END IF;
END;
'
LANGU
