Re: [GENERAL] Escape double-quotes in text[]?

2014-04-30 Thread Raymond O'Donnell
On 29/04/2014 22:54, David G Johnston wrote: Raymond O'Donnell wrote Hi all, Probably a silly question, but I'm having trouble figuring out the answer... if I'm constructing an string representation of a value to go into a text[] column, and one of the text literals includes double-quotes,

Re: [GENERAL] Escape double-quotes in text[]?

2014-04-30 Thread David G Johnston
Raymond O'Donnell wrote On 29/04/2014 22:54, David G Johnston wrote: Raymond O'Donnell wrote Hi all, Probably a silly question, but I'm having trouble figuring out the answer... if I'm constructing an string representation of a value to go into a text[] column, and one of the text literals

Re: [GENERAL] Escape double-quotes in text[]?

2014-04-30 Thread Raymond O'Donnell
On 30/04/2014 17:32, David G Johnston wrote: Raymond O'Donnell wrote On 29/04/2014 22:54, David G Johnston wrote: Raymond O'Donnell wrote Hi all, Probably a silly question, but I'm having trouble figuring out the answer... if I'm constructing an string representation of a value to go into

[GENERAL] Escape double-quotes in text[]?

2014-04-29 Thread Raymond O'Donnell
Hi all, Probably a silly question, but I'm having trouble figuring out the answer... if I'm constructing an string representation of a value to go into a text[] column, and one of the text literals includes double-quotes, do I need to escape the literal? For example, can I insert something like

Re: [GENERAL] Escape double-quotes in text[]?

2014-04-29 Thread Raymond O'Donnell
On 29/04/2014 22:10, Raymond O'Donnell wrote: Hi all, Probably a silly question, but I'm having trouble figuring out the answer... if I'm constructing an string representation of a value to go into a text[] column, and one of the text literals includes double-quotes, do I need to escape the

Re: [GENERAL] Escape double-quotes in text[]?

2014-04-29 Thread David G Johnston
Raymond O'Donnell wrote Hi all, Probably a silly question, but I'm having trouble figuring out the answer... if I'm constructing an string representation of a value to go into a text[] column, and one of the text literals includes double-quotes, do I need to escape the literal? For

Re: [GENERAL] Escape double-quotes in text[]?

2014-04-29 Thread David G Johnston
Raymond O'Donnell wrote '{abc, def}' Or would I need to do this? - E'{abc, def}' Do you realize that both of the above expressions are effectively identical? David J. -- View this message in context: