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

From: "Teemu Juntunen" <teemu(dot)juntunen(at)e-ngine(dot)fi>
To: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: SELECT ROW(t.*) FROM table t and nulls with textual representation?
Date: 2009-12-08 10:43:52
Message-ID: 133C2918D3FB42979CD440B036577DEF@eng02
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Timothy Crouch 2009-12-08 13:14:12 Unsubscribe
Previous Message Guillaume Lelarge 2009-12-08 08:02:41 Re: Tuesday (PST8PDT) Jeff Davis Presents: Operator Exclusion Constraints