Re: pg/plsql question

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Fred Blaise <fred(dot)blaise(at)excilan(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg/plsql question
Date: 2005-03-15 15:24:16
Message-ID: 4B3ED5E8-9566-11D9-9497-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mar 15, 2005, at 10:19 AM, Fred Blaise wrote:

> Just to make sure... Once the function is created, you would call it as
> 'execute function()' from psql, correct?
>

Try: select function();

As a top level SQL command, EXECUTE is for executing prepared
statements:

http://www.postgresql.org/docs/8.0/interactive/sql-execute.html

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-03-15 15:34:52 Re: pg/plsql question
Previous Message Fred Blaise 2005-03-15 15:19:16 Re: pg/plsql question