Re: Looking for auto starting procedures - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Looking for auto starting procedures
Date
Msg-id 1291335642-sup-7594@alvh.no-ip.org
Whole thread Raw
In response to Re: Looking for auto starting procedures  (<mabra@manfbraun.de>)
Responses Re: Looking for auto starting procedures  ("manfred.braun" <manfbraun@manfbraun.de>)
List pgsql-general
Excerpts from mabra's message of jue dic 02 20:04:36 -0300 2010:

> I've just not understood, when I have to write a function to test sql code
> and when I can do it interactively.

In Postgres, PL/pgSQL and SQL are two different languages.  There are
things in PL/pgSQL that you cannot do in pure SQL.  RAISE is one of
them.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: "Brent Wood"
Date:
Subject: Re: Dumping a table from one database and adding it to another
Next
From: Jonathan Vanasco
Date:
Subject: Re: how can i bugfix "idle in transaction" lockups ?