From: Josh Berkus <josh@agliodbs.com>
To: leo <lmendoza@garbersoft.net>
To: pgsql-sql@postgresql.org
Subject: Re: problem w/plpgsql proc
Date: Mon, 15 Oct 2001 08:20:24 -0700
Message-ID: <web-147888@davinci.ethosmedia.com> (raw)
In-Reply-To: <9q74ak$5v5$1@news.tht.net>
Leo,
You're gonna feel like a dork when I point it out ...
> -- if the emailaddr was found, then update the record.
> -- if it wasn't, then insert the new record.
^^^ SINGLE QUOTE HERE!! BAD!
You can't have single quotes inside a function, especially in comments.
They will be treated as the end of the function definition string.
If you write the T-SQL Procedure ---> PostgreSQL function porting guide,
I volunteer to edit (certifiable MS SQL DBA). You might wanna wait for
7.2, where Jan says that cursor support in PL/pgSQL functions will be
added.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
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: josh@agliodbs.com, lmendoza@garbersoft.net
Subject: Re: problem w/plpgsql proc
In-Reply-To: <web-147888@davinci.ethosmedia.com>
* 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