pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tomasz Myrta <jasiek@klaster.net>
To: Radu-Adrian Popescu <radu.popescu@aldratech.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL function parse error ?
Date: Thu, 09 Jan 2003 14:22:59 +0100
Message-ID: <3E1D77B3.4000503@klaster.net> (raw)
In-Reply-To: <008f01c2b7d0$3733fdf0$0600a8c0@rpopescu>
References: <008f01c2b7d0$3733fdf0$0600a8c0@rpopescu>
	<3E1D6362.80701@klaster.net>
	<00a501c2b7dc$a5c626b0$0600a8c0@rpopescu>

Radu-Adrian Popescu wrote:

> 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.

I think you are absolutely wrong.
It is possible in Postgresql to overload operators and if you want, you 
can create operator named ">$".

There is a lot of useful things in postgresql documentation. If you read 
it, you could find this:

 >CREATE OPERATOR defines a new operator, name. The user who defines an 
 >operator becomes its owner.
 >The operator name is a sequence of up to NAMEDATALEN-1 (31 by default) 
 >characters from the following list:
 >+ - * / < > = ~ ! @ # % ^ & | ` ? $

Regards,
Tomasz Myrta

view thread (19+ messages)  latest in thread

Message-ID: <3E1D77B3.4000503@klaster.net>
Permalink:  ../3E1D77B3.4000503@klaster.net/
Also on:    postgresql.org/message-id/3E1D77B3.4000503@klaster.net

copy link · copy postgr.es

reply

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: jasiek@klaster.net, radu.popescu@aldratech.com
  Subject: Re: SQL function parse error ?
  In-Reply-To: <3E1D77B3.4000503@klaster.net>

* 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