Postgres Pro
Downloads
Home   >   mailing lists

Trying to append text to the end of a text string - Mailing list pgsql-general

From Adam Lawrence
Subject Trying to append text to the end of a text string
Date
Msg-id 01d301c5c9fc$72d79600$3701a8c0@Adam
Whole thread Raw
Responses Re: Trying to append text to the end of a text string  ("Jim C. Nasby" <jnasby@pervasive.com>)
Re: Trying to append text to the end of a text string  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Trying to append text to the end of a text string  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view
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@mediasculpt.com

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Or selection on index versus union
Next
From: "Jim C. Nasby"
Date:
Subject: Re: License question[VASCL:A1077160A86]