SELECT ROW(t.*) FROM table t and nulls with textual representation? - Mailing list pgsql-general

From Teemu Juntunen
Subject SELECT ROW(t.*) FROM table t and nulls with textual representation?
Date
Msg-id 133C2918D3FB42979CD440B036577DEF@eng02
Whole thread Raw
Responses Re: SELECT ROW(t.*) FROM table t and nulls with textual representation?
List pgsql-general
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

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Tuesday (PST8PDT) Jeff Davis Presents: Operator Exclusion Constraints
Next
From: oscar arocha
Date:
Subject: logs de postgres en debian