postgres icon indicating copy to clipboard operation
postgres copied to clipboard

Custom types with dynamic columns in select statement

Open nomoney4me opened this issue 9 months ago • 0 comments

I am currently doing something like this (https://github.com/porsager/postgres?tab=readme-ov-file#dynamic-column-selection) and is seeing the same issue mentioned in #161. I added https://github.com/porsager/postgres?tab=readme-ov-file#custom-types but can't see how I can make it work with my select statement as the columns are in an array.

Does anyone have a sample piece of code that they have working to get the timestamp as a string using dynamic column in a select statement? Here is a simple example of what I'm trying to do:

var cols = ['id', 'name', 'last_created'];
var result = sql`select ${sql(cols)} from members`;

/* expecting: 
[ 
	{ 
		id: 1, 
		name: "john", 
		last_created: "2023-09-11T00:00:00.000Z"
	}
] 
*/

Thank you in advance.

nomoney4me avatar Jan 12 '25 04:01 nomoney4me