[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Trouble converting database
- Subject: Re: Trouble converting database
- From: Chris Travers <..hidden..>
- Date: Thu, 7 Jun 2012 16:12:39 -0700
On Thu, Jun 7, 2012 at 12:22 PM, Robert James Clay <..hidden..> wrote:
> On Thu, 2012-06-07 at 11:03 -0400, Chris Travers wrote:
>
>> Try this:
>>
>> select * from customer where name !~ '[[:alnum:]_]'::text;
>>
>> and the same from vendor.
>
> Both returns zero rows...
And just to be sure, selecting count(*) from these returns a number of
rows right?
Just making sure that we are hitting the right schema etc.
Best Wishes,
Chris Travers
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users