Re: [SQL] Writeable CTE Not Working?

2013-01-28 Thread Виктор Егоров
2013/1/29 Kong Man : > Can someone explain how this writable CTE works? Or does it not? They surely do, I use this feature a lot. Take a look at the description in the docs: http://www.postgresql.org/docs/current/interactive/queries-with.html#QUERIES-WITH-MODIFYING > WITH upd_code AS ( > UPDA

[SQL] Writeable CTE Not Working?

2013-01-28 Thread Kong Man
Can someone explain how this writable CTE works? Or does it not? What I tried to do was to make those non-null/non-empty values of suppliers.suppliercode unique by (1) nullifying any blank, but non-null, suppliercode, then (2) appending the supplierid values to the suppliercode values for tho