HELP! ... pg_locale ???
От | Sandis Jerics |
---|---|
Тема | HELP! ... pg_locale ??? |
Дата | |
Msg-id | 10741.001026@parks.lv обсуждение исходный текст |
Ответ на | Query Problem (Josh Berkus <josh@agliodbs.com>) |
Ответы |
Re: HELP! ... pg_locale ???
Re: HELP! ... pg_locale ??? |
Список | pgsql-sql |
Hello folks, I got a headache now, cause our admin played with postgres settings, something about pg_locale, as he says. Perhaps the reason is elsewhere, i dont know. As result, now all queries, written inside the php code on multiply lines, returns the following: ERROR: parser: parse error at or near " " The same query, pasted to psql, works well. The same query written on single line in php code works well. But i see that my older scripts with multiply line queries works well. Whats up?! Why? There is no errors in this code: ------ $result = @pg_exec($db,"SET DATESTYLE = 'ISO';SELECT DISTINCT meznieciba, date_part('day',date(datums)) AS dd, date_part('month',date(datums))AS mm, date_part('year',date(datums)) AS yyyy, galvene, kajene FROM izsolesWHERE datums= '$datums'") or die(pg_errormessage()); ------ it works fine when written on the single line but now i see the above stupid error message.. it so funny to have to rewrite queries to single line?.. --:)-- Best regards,Sandis
В списке pgsql-sql по дате отправления: