Topic: Del postgre uzklausos
Susiduriau su tokia problema, kad atrodytu postgre sql uzklausa sudaryta teisingai bet meta klaida.
pvz:
$sql = "SELECT name FROM nationalities order by name";
meta tokia klaida:
Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "ORDER" LINE 1: SELECT name FROM nationalities order by name ORDER BY 11 ^ in /var/www..
taciau kai tokia uzklausa paleidziu per phpPgAdmina:
SELECT name FROM nationalities order by name
Suveikia gerai.
Gal yra zinanciu kame cia suo pakastas? :)