phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Serega Sheypak <serega.shey...@gmail.com>
Subject select all dynamic columns by primary key if columns names are unknown
Date Tue, 02 Feb 2016 21:27:13 GMT
Hi, is it possible to select all dynamic columns if you don't know their
names in advance?
Example:

I have a table with single defined column named PK, which is a primary key

Someone runs query:

UNSERT INTO MY_TBL(PK, C1, C2, C3) VALUES('x', '1', '2', '3')

where C1, C2, C3 are dynamic columns

then I want to select all columns using query:
select * from MY_TBL where PK = 'x'
But this query won't return C1, C2, C3 columns.

Mime
View raw message