Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] pl/pgSQL doco patch

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Philip Yarra <philip(at)utiba(dot)com>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-patches(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org
Subject: Re: [PATCHES] pl/pgSQL doco patch
Date: 2005-12-08 18:03:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docspgsql-patches
I think the Oracle porting section is the correct place for this item. 
Thanks for the patch.


Philip Yarra wrote:
> On Thu, 17 Nov 2005 01:40 am, Andrew Dunstan wrote:
> > I am wondering we should make this warning more prominent - it would be
> > easily missed buried on the Oracle porting section, and I have seen
> > people caught by it lots of times.
> I added it to the Oracle section because I found this syntax while porting an 
> Oracle stored proc to a pl/pgSQL function, and assumed it was an Oracle-ism.
> Do other RDBMSs also allow you to qualify function_name.param_name to 
> distinguish a param from a column of the same name? If so, sure, I'll put it 
> somewhere more general (suggestions?), and Tom, I think that would lend 
> weight to allowing PostgreSQL to do it too (not because it's The Right Thing, 
> but for interoperability and ease of porting). Thoughts?
> Regards, Philip.
> -- 
> "Debugging is twice as hard as writing the code in the first place.
> Therefore, if you write the code as cleverly as possible, you are,
> by definition, not smart enough to debug it." - Brian W. Kernighan
> -----------------
> Utiba Pty Ltd 
> This message has been scanned for viruses and
> dangerous content by Utiba mail server and is 
> believed to be clean.
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly

  Bruce Momjian                        |
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-docs by date

Next:From: Bruce MomjianDate: 2005-12-08 21:30:19
Subject: Re: Table A-1. PostgreSQL Error Codes (WITH constants)
Previous:From: Bruce MomjianDate: 2005-12-08 18:01:54
Subject: Re: pl/pgSQL doco patch

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-12-08 21:34:10
Subject: Re: psql, tab completion additions
Previous:From: Bruce MomjianDate: 2005-12-08 18:01:54
Subject: Re: pl/pgSQL doco patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group