Totally new, two main problems.

Поиск
Список
Период
Сортировка
От wepwep
Тема Totally new, two main problems.
Дата
Msg-id 1301433633772-4270202.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Totally new, two main problems.  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
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?

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.

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Derrick Rice
Дата:
Сообщение: Re: What could keep a connection / query alive?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Date conversion using day of week