Search Postgresql Archives

SELECT ROW(t.*) FROM table t and nulls with textual representation?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,
 
is there any possibility to get null-values as text 'null' from dynamic select _expression_ like
 
SELECT ROW(t.*) FROM table t
 
Normally you get
 
(t1,t2,t3,,t5,,,)
 
How can you get
 
(t1,t2,t3,null,t5,null,null,null)
 
I would like to use the result with dynamic update _expression_ and update doesn't like of empty values, so
 
UPDATE SET (t1,t2,t3,t4,t5,t6,t7,t8) = (t1,t2,t3,,t5,,,)
 
generates error.
 
 
Best regards,
Teemu Juntunen, e-ngine

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux