Re: problem w/plpgsql proc

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: leo <lmendoza(at)garbersoft(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: problem w/plpgsql proc
Date: 2001-10-15 15:20:24
Message-ID: web-147888@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

Attachment Content-Type Size
unknown_filename text/plain 2 bytes
unknown_filename text/plain 2 bytes
unknown_filename text/plain 2 bytes

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-10-15 15:20:44 Re: problem w/plpgsql proc
Previous Message Josh Berkus 2001-10-15 15:13:11 Re: SQL reference card