I am having problems doing what seems to be a very simple thing. All I
need is to join 2 or more variables (eg char, int, date) and return them
as a single varchar variable.
eg ret := int + char + date; or better still join("+", int,char,date)
some additional info. I have read in the documentation that you can
concat with the || operator. However because one or more of the
variables may be empty this seems not to work. If one of the variables
is empty nothing is returned.
Please can anyone help.
Thanks in advance David Mulcahy.
pgsql-novice by date
|Next:||From: Andrew McMillan||Date: 2001-09-07 23:06:45|
|Subject: Re: pl/pgsql function problem|
|Previous:||From: Bo Lorentsen||Date: 2001-09-07 06:15:15|
|Subject: Re: pl/pgsql recursion/arrays (fwd)|