[GENERAL] query string too long

1999-10-01 Thread leshan
Does any one know a way around the query string too long error? I am trying to create a view. Below is the create command and the error message. Thank you, Jd create view external_job as select positions.id as position_id, positions.title as position_title, external, expire, never,

[GENERAL] Subject: String Concatenation does not work.

1999-01-06 Thread leshan
>I tried to place a query like "SELECT * FROM x WHERE a = b || c" where > a, b and c are text columns in table x. > Unfortunately all I get are Syntax Errors pointing to the concatenation > operator. This happens under 6.3. with psql and jdbc. > Am I just tripping over a bug or do have to use some