Re: join with 1 row limit

Behringer Behringer <behringerdj@yahoo.com> writes:
> 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

When asking that sort of question, it would be a good idea to explain
exactly what you expect that syntax to do.  Not all of us know every
nook and cranny of mysql's nonstandard behaviors.

            regards, tom lane