Re: [GENERAL] repeated characters in SQL

2016-01-24 Thread Tom Lane
Francisco Olarte writes: > On Sun, Jan 24, 2016 at 7:05 PM, wrote: >> I guess the escape character (which is not needed in, say, Notepad++) threw >> me a bit. > Notepad ++ is, AFAIK, an editor, it SHOULD (within reason) let you > write any text. > The double quote is needed due to the quoting

Re: [GENERAL] repeated characters in SQL

2016-01-24 Thread Francisco Olarte
On Sun, Jan 24, 2016 at 7:05 PM, wrote: > I guess the escape character (which is not needed in, say, Notepad++) threw > me a bit. Notepad ++ is, AFAIK, an editor, it SHOULD (within reason) let you write any text. The double quote is needed due to the quoting rules of the language. You want the

Re: [GENERAL] repeated characters in SQL

2016-01-24 Thread rashapoo
Thanks David...so it's looking at each character, storing it in /1, then comparing the "next" character with what is in /1. I guess the escape character (which is not needed in, say, Notepad++) threw me a bit. On Sun, Jan 24, 2016 at 2:32 AM, David Rowley wrote: > On 24 January 2016 at 12:44, Go

Re: [GENERAL] repeated characters in SQL

2016-01-23 Thread David Rowley
On 24 January 2016 at 12:44, Govind Chettiar wrote: > I have a simple table consisting of a bunch of English words. I am trying > to find words that have repeated characters in them, for example > apple > tattoo > > but not > > orange > lemon > > I know that only a maximum of one repetition can o

[GENERAL] repeated characters in SQL

2016-01-23 Thread Govind Chettiar
I have a simple table consisting of a bunch of English words. I am trying to find words that have repeated characters in them, for example apple tattoo but not orange lemon I know that only a maximum of one repetition can occur I tried various options like SELECT word FROM public."SpellItWord