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,
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,
;
> 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]'
>
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:/