Greetings,
Could someone please help with creating the following function:
As a psql command it would be
set var4 = upper(rpad(var1, 5, '-')) || lower(rpad(var2, 5, '-')) ||
lpad(var3, 5, '0'))
All variables are text.
I am attempting to assign a value to var4 that concatenates var 1, 2 & 3. As
Var 1 to 3 may collectively exist on several tables -- i.e a.1, a.2, a.3 vs
b.1, b.2, and b.3 -- but all results for var4 will be inserted into yet
another table "var4".
Example:
Table "Client" contains
ID
SURNAME
GIVEN
Table "author" contains
ID
SURNAME
GIVEN
Table "nick" would contain
NICK (var4)
table of origin
SURNAME
I have attempted to create this procedure as a function:
CREATE FUNCTION nick_sur (text, text, text)
RETURNS TEXT
as
... balance of above sql stmt.
both with and without the 'set =' prefix, using both 'text' and '$1', '$2',
and '$3' in place of 'var(x)' and combinations of the preceding, also with
the language (sql) quoted and not qutoed.
I've searched the documentation, '\h create function' and the postgres site,
but can't seem to get the right syntax for creating this function.
Many thanks,
C-Cose Masters
