Trying to append text to the end of a text string

["Adam Lawrence" <adam@xxxxxxxxxxxxxxx>]

Hi

 

I am trying to append text onto the end of a text variable.

 

I have the text variable P_IDT_ID, I want to add the letter S to the end of it, so I tried the following line in my code:

 

P_IDT_ID := P_IDT_ID && cast(''S'' as text);

 

However, I got the following error message:

 

ERROR:  operator does not exist: text && text
HINT:  No operator matches the given name and argument type(s). You may need to add explicit type casts.
CONTEXT:  SQL statement "SELECT   $1  && cast('S' as text)"
PL/pgSQL function "f_create_index_currency_inversion" line 28 at assignment

Note I am using PL/pgSQL.

 

 

Can you help?

 

Thanks

Adam

 

Adam Lawrence
Mediasculpt

 

Direct Line: +64 6 3546038
Email: adam@xxxxxxxxxxxxxxx