public inbox for [email protected]
help / color / mirror / Atom feedFrom: [email protected]
To: [email protected]
Subject: incorrect data type in function
Date: Sat, 21 May 2016 14:00:46 +0000
Message-ID: <[email protected]> (raw)
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>
The following documentation comment has been logged on the website:
Page: http://www.postgresql.org/docs/8.2/static/plpgsql-porting.html
Description:
on page :
http://www.postgresql.org/docs/current/static/plpgsql-porting.html
under 40.12.1. Porting Examples -> Example 40-8. Porting a Simple Function
from PL/SQL to PL/pgSQL
======================================
CREATE OR REPLACE FUNCTION cs_fmt_browser_version(v_name varchar,
v_version varchar)
RETURN varchar IS
BEGIN
IF v_version IS NULL THEN
RETURN v_name;
END IF;
RETURN v_name || '/' || v_version;
END;
/
show errors;
======================================
The data types in the function parameter and the returned type were seems
typed incorrectly or missed typo ... in ORACLE there is no varchar, but
there is varchar2
And since I AM away from ORACLE for more than decade, I might be wrong.
Appreciate your efforts in keeping the best as open source.
Thanks,
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: incorrect data type in function
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox