END

END

Name

END  --  commit the current transaction

Synopsis

END [ WORK | TRANSACTION ]
  

Inputs

WORK
TRANSACTION

Optional keywords. They have no effect.

Outputs

COMMIT

Message returned if the transaction is successfully committed.

WARNING: COMMIT: no transaction in progress

If there is no transaction in progress.

Description

END is a PostgreSQL extension, and is a synonym for the SQL92-compatible COMMIT.

Notes

The keywords WORK and TRANSACTION are noise and can be omitted.

Use ROLLBACK to abort a transaction.

Usage

To make all changes permanent:

END WORK;
   

Compatibility

SQL92

END is a PostgreSQL extension which provides functionality equivalent to COMMIT.

Home
Online Resources
General
Beginner Tutorials
MySQL
PostgreSQL
Oracle
mSQL
Microsoft SQL
Contact Us
Random quote of the moment:
The recent proliferation of Nuclear Testing
 
http://www.sql.org/
 
Proudly designed and hosted by OmegaSphere, providers of all your Web Hosting, SSL Certificate, and Domain Name needs!