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
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
