[SQL] PostgreSQL and uuid/guid

2006-01-02 Thread Mario Splivalo
Hello all. While browsing the web I've seen that many people 'need' the ability to create uuid/guid values from within the PostgreSQL. Most of them are switching from MSSQL, and they're missing the newid() function, which in MSSQL created the uuid/guid value. Now I'm in need of such function

[SQL] delete from a using b in postgres 8.1.

2006-01-02 Thread Peter Childs
a command such as delete from a using b where a. and b.two='foo'; works fine in 8.1 but fails totally in 8.0 however delete from a where a. and b.two='foo'; works fine in 8.0 and bellow but fails in 8.1 unless you have the add_missing_from option set to true in 8.1 Even then it produces a