Re: [SQL] problem with select where like ']'

2000-10-18 Thread Peter Eisentraut
Joseph Shraibman writes: > The only way I can find is to do a search on something, and select to > search in mailing lists. Then after the search returns click on a link, > and trucate the url to http://www.postgresql.org/mhonarc/ When in doubt, use geocrawler.com. -- Peter Eisentraut [EM

Re: [SQL] problem with select where like ']'

2000-10-17 Thread Vince Vielhaber
http://www.postgresql.org/users-lounge/index.html has most of them. Actually it's under General Info from the user's lounge. It was brought to my attention today that the list of archives was incomplete so I'll be adding to it and adding another one (developer and user). Don't get too attache

Re: [SQL] problem with select where like ']'

2000-10-17 Thread Bruce Momjian
> > http://www.postgresql.org/users-lounge/index.html has most of them. > Actually it's under General Info from the user's lounge. > > It was brought to my attention today that the list of archives was > incomplete so I'll be adding to it and adding another one (developer > and user). Don't g

Re: [SQL] problem with select where like ']'

2000-10-17 Thread Joseph Shraibman
The only way I can find is to do a search on something, and select to search in mailing lists. Then after the search returns click on a link, and trucate the url to http://www.postgresql.org/mhonarc/ Bruce Momjian wrote: > > The fact is, I can't figure out how to get there without the URL. > >

Re: [SQL] problem with select where like ']'

2000-10-17 Thread Bruce Momjian
The fact is, I can't figure out how to get there without the URL. > Joseph Shraibman <[EMAIL PROTECTED]> writes: > > WHAT mailing list archives? > > They aren't linked to anywhere on www.postgresql.org that I can find. > > Hmm. My bookmark is > > http://www.postgresql.org/lists/mailing-list.h

Re: [SQL] problem with select where like ']'

2000-10-17 Thread Tom Lane
Joseph Shraibman <[EMAIL PROTECTED]> writes: > WHAT mailing list archives? > They aren't linked to anywhere on www.postgresql.org that I can find. Hmm. My bookmark is http://www.postgresql.org/lists/mailing-list.html Dunno how to get there from the site toplevel... reg

Re: [SQL] problem with select where like ']'

2000-10-17 Thread Joseph Shraibman
Tom Lane wrote: > > hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > > but i'm just wondering why like ']' doesn't work. > > What LOCALE setting are you running the postmaster in? > > ']' is not a special character as far as LIKE is concerned, but > I suspect you may be seeing another va

Re: [SQL] problem with select where like ']'

2000-10-17 Thread KuroiNeko
> hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > > but i'm just wondering why like ']' doesn't work. > > What LOCALE setting are you running the postmaster in? > > ']' is not a special character as far as LIKE is concerned, but > I suspect you may be seeing another variant of the problems

Re: [SQL] problem with select where like ']'

2000-10-17 Thread Tom Lane
hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > but i'm just wondering why like ']' doesn't work. What LOCALE setting are you running the postmaster in? ']' is not a special character as far as LIKE is concerned, but I suspect you may be seeing another variant of the problems that LIKE i

[SQL] problem with select where like ']'

2000-10-17 Thread hubert depesz lubaczewski
hi, i have a table (view actually) which contains field "article_name" which is written like: [AGD]|[Kuchenki Mikrofalowe]|[Samsung AKMS1] i.e. some string within "[]" delimited by "|" i want to select all record that have "[AGD]|[" in front of them so i tried select * from my_view where article_