Re: [BUGS] LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...
John Lumby writes: > psql -d proteusdb -c "select count(*) from entity as e1 where ( > e1.association_id IN ( select id from entity as e2 where > e2.parent_id=3043508) OR e1.association_id=3043508 ) and e1.discriminator > LIKE 'DEPLOY%'"; > ERROR: could not determine which collation to use for string comparison > HINT: Use the COLLATE clause to set the collation explicitly. FWIW, I tried to replicate this on the basis of the limited information you gave, and could not. Can you provide a self-contained test case? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] About Wince App
Hi Cihan-san. First, official support does not have Postgrs about WinCE. Next, I had tried libpq by WinCE (mobile) in the past. But, My telephone is Android now...therefore, I forgotten about WinCE.,sorry... Probably, Peter-san know detailed to it.:-) Regards, Hiroshi Saito (2011/12/10 0:07), Cihan ŞENGÜL wrote: Hi; PostgresqltowinceVS2003applicationsoropen sourcecodefor theDLL,I needsupport. Cihan ŞENGÜL (2011/12/10 23:27), Cihan wrote: > libpqwce. NET version of VB 2003 here? > -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] About Wince App
On 10 December 2011 15:13, Hiroshi Saito wrote: > First, official support does not have Postgrs about WinCE. > > Next, I had tried libpq by WinCE (mobile) in the past. > But, My telephone is Android now...therefore, I forgotten > about WinCE.,sorry... Yes, I used Hiroshi's WinCE libpq port very successfully. I built it from source too, as there were binary compatibility problems with some of the ARM devices that had custom WinCE kernels (not uncommon - WinCE is available under a "shared source" agreement), but not others that didn't. What's the problem? :-) -- Peter Geoghegan http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
