X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E0CC19DCA05 for ; Mon, 27 Mar 2006 17:38:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86016-02 for ; Mon, 27 Mar 2006 17:38:33 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 7080C9DCA24 for ; Mon, 27 Mar 2006 17:38:30 -0400 (AST) Received: from smtpq1.tilbu1.nb.home.nl (smtpq1.tilbu1.nb.home.nl [213.51.146.200]) by svr4.postgresql.org (Postfix) with ESMTP id E3BD75AF04D for ; Mon, 27 Mar 2006 21:38:32 +0000 (GMT) Received: from [213.51.146.189] (port=46182 helo=smtp2.tilbu1.nb.home.nl) by smtpq1.tilbu1.nb.home.nl with esmtp (Exim 4.30) id 1FNzPw-0003as-L7 for pgsql-sql@postgresql.org; Mon, 27 Mar 2006 23:38:28 +0200 Received: from cc503261-a.eelde1.dr.home.nl ([212.204.130.36]:58488 helo=[192.168.1.4]) by smtp2.tilbu1.nb.home.nl with esmtp (Exim 4.30) id 1FNzPv-0006DR-Bp for pgsql-sql@postgresql.org; Mon, 27 Mar 2006 23:38:27 +0200 Message-ID: <44285B53.2070809@gmail.com> Date: Mon, 27 Mar 2006 23:38:27 +0200 From: Wiebe Cazemier User-Agent: Mozilla Thunderbird 1.0.7 (X11/20060225) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: unique names in variables and columns in plsql functions References: <4427F7D3.3000103@gmail.com> <20060327144804.GV80726@pervasive.com> In-Reply-To: <20060327144804.GV80726@pervasive.com> X-Enigmail-Version: 0.93.0.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig0AC8CCEECA6B46D891C2D013" X-AtHome-MailScanner-Information: Please contact support@home.nl for more information X-AtHome-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/437 X-Sequence-Number: 24783 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig0AC8CCEECA6B46D891C2D013 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit (Whoops, pressed wrong reply button. Here it is correctly this time.) On 03/27/06 16:48, Jim C. Nasby wrote: > >Sadly, overloading variable names between plpgsql and SQL is *highly* >problematic. Because of this I *always* prefix plpgsql variables with >something, such as p_ for parameters and v_ for general variables. > > Hmm. Well, at least now I'm aware of it. Perhaps I will do something similair to prefixes from now on, it would seem to be good practice. --------------enig0AC8CCEECA6B46D891C2D013 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFEKFtTMHkUjYo9d9ARAhpWAJ9W1WPGtZUK1Dg+z8zNTvbFiEhYOQCeIoKg tej4RlugPhv68lOYuBn3iWk= =fujg -----END PGP SIGNATURE----- --------------enig0AC8CCEECA6B46D891C2D013--