Re: Totally new, two main problems.

On Tuesday, March 29, 2011 2:20:33 pm wepwep wrote:
> Im learning pg sql and psql in general. Im using console psql in windows.
> For now, i installed it correctly and execute it, ok.
>
> My first problem is that i dont know how to execute a pgsql script when im
> in the psql program.
> CREATE FUNCTION sales_tax(subtotal real) RETURNS real AS $$
> BEGIN
> RETURN subtotal * 0.06;
> END;
> $$ LANGUAGE plpgsql;
>
>
> This is in c:/2tri/scr.sql. How i can execute that?

From in psql> \i c:/2tri/scr.sql will load the function into the database,
assuming the user you are logged in has appropriate permissions. FYI I would use
the form CREATE OR REPLACE FUNCTION. This allows you change an existing function
without dropping it.

Then do :
select sales_tax(150.24);

>
> Also my other problem is with pgsql syntax. How i can print a text to the
> console for checking, debugign, etc, i dont see anything to do that.

See here:
http://www.postgresql.org/docs/9.0/interactive/plpgsql-errors-and-messages.html

If you are using 9.0+ you might also want to check out DO:
http://www.postgresql.org/docs/9.0/interactive/sql-do.html

>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Totally-new-two-main-problems-tp42
> 70202p4270202.html Sent from the PostgreSQL - general mailing list archive
> at Nabble.com.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com