Zeoslib Portal

Ok, now I undersand, I didn't know about the PostgreSQL arrays. I fixed it so it works, but the legacy is a big issue (that's why I made this change in the firt place, to deal with my own legacy queries).

I don't think this should be included if breaks any backwards compatibility.

I don't understand your question but maybe this example will help: select 'HELLO:WORLD'::varchar, * from TEST_TABLE where ID = :ID and NAME <> 'SOME:THING' This query works fine, the tokenizer doesn't get confused between ':' and '::', so you write de query the same just like you do in pg_admin. Or ...

Adding that line does not avoid the use of single ':', I tested queries with params and they work fine. The same way the previous line ( Add('>>') ) doesn't avoid the use of a single '>'. On the other hand, the current solution requires to escape characters when writing queries. Not a big problem on...

Just add the marked line, otherwise it'll be treated as a parameter and throws syntax error constructor TZPostgreSQLSymbolState.Create; begin inherited Create; Add('<='); Add('>='); Add('<>'); Add('<<'); Add('>>'); + Add('::'); end; sample query: SELECT ID, 'HELLO'::varchar FROM TABLE thaks a lot ex...