In mysql this query works fine, what is the equivalent in posgresql?
SELECT *
FROM
products p LEFT JOIN
products_images pi ON p.id = pi.product_id LIMIT 1
WHERE products.company = 7
postgresql complains about LIMIT
This also fails
SELECT p.*
FROM
products p LEFT JOIN
(SELECT id,server_id,format,product_id FROM products_images pi WHERE pi.product_id = p.id LIMIT 1) pi ON pi.product_id
=p.id
WHERE p.store_id = 1
with
There is an entry for table "p", but it cannot be referenced from this part of the query.
also this fails
SELECT p.*,
(SELECT id,server_id,format,product_id FROM products_images pi WHERE pi.product_id = p.id LIMIT 1) as AS pi(id, type)
FROM products p
WHERE p.store_id = 1
thanks