Re: [GENERAL] php + postgresql website ?

2008-06-30 Thread Ian Meyer
http://board.crewcial.org currently in flux as we're finishing up a dev version, but we've been running postgres since 7.4, currently on 8.1.. with around 7 million rows of data totaling a few GB. traffic is around 300k hits a day. nothing crazy, but it works really well. - ian On Mon, Jun 30,

Re: [GENERAL] Method to detect certain characters in column?

2008-06-23 Thread Ian Meyer
with not enough experience to sanity check everything, or do things as we're doing now. And yeah, that's how the names are. People got crafty. *shrugs* thanks again for all the help everyone! On Mon, Jun 23, 2008 at 11:54 PM, Tino Wildenhain <[EMAIL PROTECTED]> wrote: > Hi Ian,

Re: [GENERAL] Method to detect certain characters in column?

2008-06-23 Thread Ian Meyer
; > On Jun 23, 2008, at 1:58 PM, Ian Meyer wrote: > >> So I have a column that contains usernames that have characters such >> as Ã(c)(R), for example: fuchÃ(c)r.. is there any way to find names >> with non A-Za-z0-9? > > ... WHERE column ~* '[^a-z0-9]' >

[GENERAL] Method to detect certain characters in column?

2008-06-23 Thread Ian Meyer
So I have a column that contains usernames that have characters such as Ã(c)(R), for example: fuchÃ(c)r.. is there any way to find names with non A-Za-z0-9? Thanks in advance! - Ian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http:/