DataBase/Postgresql(8)
-
postgre SQL : 예외처리
예외처리? 오류처리? 음..anyways...찾아보니 RAISE 라는 것과 Exception이라는 것이 있는 것 같다. 우선 EXCEPTION 을 학습하고 적용시켜 보자^-^ http://www.postgresql.org/docs/8.0/static/plpgsql-control-structures.html By default, any error occurring in a PL/pgSQL function aborts execution of the function, and indeed of the surrounding transaction as well. You can trap errors and recover from them by using a BEGIN block with an EXCEPTION cla..
2012.11.21 -
postgresql 학습하기
pgAdmin...오픈소스 데이타베이스라고 한다. 와우! 학습해보자~~+ㅁ+/ http://www.postgresql.org/docs/8.1/static/plpgsql-development-tips.html 프로시저 or 함수를 사용해보자^-^ PL/pgSQL - SQL Procedural Language 36.11. Porting from Oracle PL/SQL http://www.postgresql.org/docs/8.1/static/plpgsql-porting.html#PLPGSQL-PORTING-EX2 This section explains differences between PostgreSQL's PL/pgSQL language and Oracle's PL/SQL language, to hel..
2012.11.21