Re: [GENERAL] Replicating PostgreSQL DB to lightweight system

2006-05-02 Thread pgdb
David Fetter writes: David Fetter writes: > On Wed, May 03, 2006 at 02:31:19AM +0000, pgdb wrote: >> Hi, > >> like to know if I can replicate a PG db to another lightweight >> platform like SQLite? The objective is to "push" updates to remote >> d

[GENERAL] Replicating PostgreSQL DB to lightweight system

2006-05-02 Thread pgdb
them thru' the small-footprint db system. Would be glad to hear if there are examples of existing commercial/OSS products to serve the purpose. Appreciate any advice. Thanks.   Regards pgdb Free POP3 Email from www.gawab.com Sign up NOW and get your account @gawab.com!!

Re: [GENERAL] Regex with patterns in table field

2006-04-14 Thread pgdb
Hi Chris,   the query below works for me -   select * from TABLENAME where 'TEXT' ~ pattern;   Thanks for helping!   Regards   chris smith writes: > On 4/14/06, pgdb <[EMAIL PROTECTED]>wrote: >> >> >> Hi Andreas, >> >> strange but I don&#x

Re: [GENERAL] Regex with patterns in table field

2006-04-13 Thread pgdb
text in regular _expression_ have to be just a single string(with no white character) for my case. Matching should then be done with patterns from each row, returning the row(s) that contain matching regex pattern(s). Appreciate any advice. Thanks.   Regards pgdb   A. Kretschmer writes: > am 13.04

[GENERAL] Regex with patterns in table field

2006-04-13 Thread pgdb
Hi,   like to know how, if possible, for patterns as attribute in a table to be used in a regex search with a fixed string. The query should therefore return the rows that have matching patterns with the single text.   Regards pgdb Free POP3 Email from