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;
'
Its a typo..it should be RETURNS BOOLEAN and not RETURN BOOLEAN
-Sharmila
--- On Mon, 2/23/09, SHARMILA JOTHIRAJAH sharmi...@yahoo.com wrote:
From: SHARMILA JOTHIRAJAH sharmi...@yahoo.com
Subject: Function that returns Boolean
To: General postgres mailing list pgsql-general@postgresql.org
SHARMILA JOTHIRAJAH sharmi...@yahoo.com 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
- SHARMILA JOTHIRAJAH sharmi...@yahoo.com 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
On Mon, Feb 23, 2009 at 9:39 AM, SHARMILA JOTHIRAJAH
sharmi...@yahoo.com 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
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