KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
How can I extract the values from a record as individual comuns in postgresql SELECT p.*, (SELECT ROW(id,server_id,format,product_id) FROM products_images pi WHERE pi.product_id = p.id LIMIT 1) AS image FROM products p WHERE p.company = 1 ORDER BY id ASC LIMIT 10 Instead of image (3, 4, "jpeg", 7) I would like to have id | server_id | format | product_id 3 | 4 | jpeg | 7 Is there any way of selecting only one image for each product and return the columns directly instead of a record?
Tags (comma-separated)
Save Edits
Cancel