From: Radu-Adrian Popescu <radu.popescu@aldratech.com>
To: pgsql-sql@postgresql.org
Subject: Re: SQL function parse error ?
Date: Thu, 9 Jan 2003 14:43:02 +0200
Message-ID: <00a501c2b7dc$a5c626b0$0600a8c0@rpopescu> (raw)
References: <008f01c2b7d0$3733fdf0$0600a8c0@rpopescu>
<3E1D6362.80701@klaster.net>
I'm perfectly aware of the fact that a space solves the issue here.
What I'm saying is that it is not natural nor common to take some whitespace
into
account when parsing, since this is not bash language, nor python, as it
shouldn't be !
This is SQL, and people who are using PostgreSql write SQL, not
whitespace-sensitive SQL, bash or whatever.
And besides, like I have already pointed out, look at php's language parser
(behavior, not source) :
the statement if(100>$a) is perfectly legal, as it should be.
Is there any operator named >$ ?
Anyone who has used anything from Mysql to Oracle will get quite annoyed on
this one.
Hope the people in charge of the parser will get to the bottom of this...
... and please forgive my caustic tone.
=====
Radu-Adrian Popescu
CSA, DBA, Developer
Aldratech Ltd.
----- Original Message -----
From: "Tomasz Myrta" <jasiek@klaster.net>
To: "Radu-Adrian Popescu" <radu.popescu@aldratech.com>
Cc: <pgsql-sql@postgresql.org>
Sent: Thursday, January 09, 2003 1:56 PM
Subject: Re: [SQL] SQL function parse error ?
Radu-Adrian Popescu wrote:
>
> Take the following for example:
> create or replace function testfunc1(int) returns setof test as
> '
> select * from test where age>$1;
> ' ^^^^^^
> language sql;
I didn't find it in documentation, but sql functions are like bash (you
forgot about space character):
create or replace function testfunc1(int) returns setof test as
'
select * from test where age > $1;
'
works fine.
Postgresql thinks that >$ is an operator instead of >
Tomasz Myrta
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: radu.popescu@aldratech.com
Subject: Re: SQL function parse error ?
In-Reply-To: <00a501c2b7dc$a5c626b0$0600a8c0@rpopescu>
* 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