File: ex12.sql

package info (click to toggle)
pgformatter 5.9-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 7,964 kB
  • sloc: sql: 186,493; perl: 5,694; makefile: 2; sh: 1
file content (15 lines) | stat: -rw-r--r-- 427 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
SET client_encoding TO 'UTF8';

UPDATE weather SET temp_lo = temp_lo+1, temp_hi = temp_lo+15, prcp = DEFAULT
  WHERE city = 'San Francisco' AND date = '2003-07-03' RETURNING temp_lo,temp_hi,prcp;

\set ON_ERROR_STOP ON

SELECT * FROM (SELECT * FROM mytable FOR UPDATE) AS ss WHERE col1 = 5;

BEGIN;
SELECT * FROM mytable WHERE key = 1 FOR NO KEY UPDATE;
SAVEPOINT s;
UPDATE mytable SET col1=NULL WHERE key = 1;
ROLLBACK TO s;