From: | DaNieL <daniele(dot)pignedoli(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | ERROR: syntax error at or near "IF"... why? |
Date: | 2009-04-29 14:54:20 |
Message-ID: | 4a0a8510-8a08-4194-ba35-1e6760e50ced@x1g2000prh.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi guys, im new with postgresql, and already got my first problem..
Well, I wroted some code for understend how the transaction works,
following step by step the manual.
TO make it short, i've created 2 tables, user and movements: in the
firs one there are the name, email and credit colons, in the second
the colons from, to, import.
So, i was triyng that way:
BEGIN;
INSERT INTO movements (from, to, import) VALUES ('mary', 'steve',
600);
UPDATE users SET credit = credit - 600 WHERE name = 'mary';
UPDATE users SET credit = credit + 600 WHERE name = 'steve';
--here comes the problem!
IF (SELECT credit FROM users WHERE name = 'mary') < 0 THEN
ROLLBACK;
END IF
COMMIT;
i always get the error
ERROR: syntax error at or near "IF"
Where am i mistaken?
p.s: dont focus on the example functionality, its just a trial for me
to understand the transactions.. and now, the IF clause...
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2009-04-29 15:59:22 | Re: [Slony1-general] pgpass.conf for Windows Vista |
Previous Message | Peter Geoghegan | 2009-04-29 14:52:52 | Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully |