From: Sandis Jerics <sandis@mediaparks.lv>
To: pgsql-sql@postgresql.org
Subject: HELP! ... pg_locale ???
Date: Thu, 26 Oct 2000 17:48:26 +0300
Message-ID: <10741.001026@parks.lv> (raw)
In-Reply-To: <39F78FE7.DA915769@agliodbs.com>
References: <39F78FE7.DA915769@agliodbs.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: sandis@mediaparks.lv
Subject: Re: HELP! ... pg_locale ???
In-Reply-To: <10741.001026@parks.lv>
References: <39F78FE7.DA915769@agliodbs.com> <10741.001026@parks.lv>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox