pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
plpgsql syntax
3+ messages / 3 participants
[nested] [flat]

* plpgsql syntax
@ 2004-09-23 15:32  Kemin Zhou <kemin.zhou@ferring.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Kemin Zhou @ 2004-09-23 15:32 UTC (permalink / raw)
  To: pgsql-sql

I just want to bring up a point for discussion:
for the function definition is treated as a long string right now.  Why 
not add an additional token so that we don't have to write 10 single quotes.

for example
create function a_func() return integer as
.....
end a_func

 after as and before end a_func marks the definition body. Would this be 
better than the ' '?
Kemin





**********************************************************************
Proprietary or confidential information belonging to Ferring Holding SA or to one of its affiliated companies may be contained in the message. If you are not the addressee indicated in this message (or responsible for the delivery of the message to such person), please do not copy or deliver this message to anyone. In such case, please destroy this message and notify the sender by reply e-mail. Please advise the sender immediately if you or your employer do not consent to e-mail for messages of this kind. Opinions, conclusions and other information in this message represent the opinion of the sender and do not necessarily represent or reflect the views and opinions of Ferring.
**********************************************************************




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: plpgsql syntax
@ 2004-09-23 16:02  Yasir Malik <ymalik@cs.stevens-tech.edu>
  parent: Kemin Zhou <kemin.zhou@ferring.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Yasir Malik @ 2004-09-23 16:02 UTC (permalink / raw)
  To: pgsql-sql

> for example
> create function a_func() return integer as
> .....
> end a_func
>
> after as and before end a_func marks the definition body. Would this be 
> better than the ' '?

I guess having a parser that gave better error messages would be nice, 
too.

Yasir



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: plpgsql syntax
@ 2004-09-23 16:19  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Kemin Zhou <kemin.zhou@ferring.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-09-23 16:19 UTC (permalink / raw)
  To: Kemin Zhou <kemin.zhou@ferring.com>; +Cc: pgsql-sql

Kemin Zhou <kemin.zhou@ferring.com> writes:
> I just want to bring up a point for discussion:
> for the function definition is treated as a long string right now.  Why 
> not add an additional token so that we don't have to write 10 single quotes.

Something's already been done about this for 8.0.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-09-23 16:19 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-23 15:32 plpgsql syntax Kemin Zhou <kemin.zhou@ferring.com>
2004-09-23 16:02 ` Yasir Malik <ymalik@cs.stevens-tech.edu>
2004-09-23 16:19 ` Tom Lane <tgl@sss.pgh.pa.us>

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