Received: from hub.org.org (localhost [127.0.0.1]) by hub.org (8.10.1/8.11.0) with SMTP id e9QKltU18068 for ; Thu, 26 Oct 2000 16:47:55 -0400 (EDT) (envelope-from pgsql-sql-owner@hub.org) Received: from webmail.parks.lv (root@smtp.parks.lv [195.2.96.248]) by hub.org (8.10.1/8.11.0) with ESMTP id e9QFnCU17921 for ; Thu, 26 Oct 2000 11:49:12 -0400 (EDT) (envelope-from sandis@mediaparks.lv) Received: from sandis.mediaparks.lv ([195.2.123.209]) by webmail.parks.lv (8.8.8/8.8.0) with ESMTP id e9QFn8I04078 for ; Thu, 26 Oct 2000 17:49:09 +0200 Date: Thu, 26 Oct 2000 17:48:26 +0300 From: Sandis Jerics X-Mailer: The Bat! (v1.41) X-Priority: 3 (Normal) Message-ID: <10741.001026@parks.lv> To: pgsql-sql@postgresql.org Subject: HELP! ... pg_locale ??? In-reply-To: <39F78FE7.DA915769@agliodbs.com> References: <39F78FE7.DA915769@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/250 X-Sequence-Number: 1917 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 izsoles WHERE 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