Re: [HACKERS] Backslash handling in strings

2005-06-01 Thread Bruce Momjian
Here is a summary of the issues with moving to no escapes for non-E strings: http://candle.pha.pa.us/cgi-bin/pgescape --- Bruno Wolff III wrote: > On Tue, May 31, 2005 at 11:49:20 +0200, > Dennis Bjorklund <[EMAIL

Re: [HACKERS] Backslash handling in strings

2005-05-31 Thread Bruno Wolff III
On Tue, May 31, 2005 at 11:49:20 +0200, Dennis Bjorklund <[EMAIL PROTECTED]> wrote: > On Tue, 31 May 2005, Tom Lane wrote: > > > The case that convinced me we need to keep some sort of backslash > > capability is this: suppose you want to put a string including a tab > > into your database. Try

Re: [HACKERS] Backslash handling in strings

2005-05-31 Thread Bruce Momjian
Tom Lane wrote: > Greg Stark <[EMAIL PROTECTED]> writes: > > The only thing I'm not clear on is what exactly is the use case for E'' > > strings. That is, who do you expect to actually use them? > > The case that convinced me we need to keep some sort of backslash > capability is this: suppose you

Re: [HACKERS] Backslash handling in strings

2005-05-31 Thread Dennis Bjorklund
On Tue, 31 May 2005, Tom Ivar Helbekkmo wrote: > ...or ^V followed by TAB, as per age-old tradition. :-) Right, I forgot about that one. One can also do other control characters instead of TAB by pressing CTRL-J and similar. Well, I just wanted to point out that it's possible. The main problem

Re: [HACKERS] Backslash handling in strings

2005-05-31 Thread Tom Ivar Helbekkmo
Dennis Bjorklund <[EMAIL PROTECTED]> writes: > To insert a tab using readline you can press ESC followed by TAB. ...or ^V followed by TAB, as per age-old tradition. :-) -tih -- Don't ascribe to stupidity what can be adequately explained by ignorance. ---(end of broadca

Re: [HACKERS] Backslash handling in strings

2005-05-31 Thread Dennis Bjorklund
On Tue, 31 May 2005, Tom Lane wrote: > The case that convinced me we need to keep some sort of backslash > capability is this: suppose you want to put a string including a tab > into your database. Try to do it with psql: > t=> insert into foo values (' > Guess what: you won't get anywhere,

Re: [HACKERS] Backslash handling in strings

2005-05-30 Thread Tom Lane
Greg Stark <[EMAIL PROTECTED]> writes: > The only thing I'm not clear on is what exactly is the use case for E'' > strings. That is, who do you expect to actually use them? The case that convinced me we need to keep some sort of backslash capability is this: suppose you want to put a string includ

Re: [HACKERS] Backslash handling in strings

2005-05-30 Thread Bruce Momjian
Greg Stark wrote: > Bruce Momjian writes: > > > The goal, at some point, is that we would have two types of strings, '' > > strings and E'' strings. '' strings don't have any special backslash > > handling for compatibility with with the ANSI spec and all other > > databases except MySQL (and in

Re: [HACKERS] Backslash handling in strings

2005-05-30 Thread Greg Stark
Bruce Momjian writes: > The goal, at some point, is that we would have two types of strings, '' > strings and E'' strings. '' strings don't have any special backslash > handling for compatibility with with the ANSI spec and all other > databases except MySQL (and in MySQL it is now optional). E