Re: convert query from mysql

thank you Kevin, works a treat.

so simple...

 

time to buy some postgres books I reckon.

 

>>> Kevin Grittner <kgrittn@ymail.com> 12/17/2013 1:36 PM >>>

Mike Andrewjeski <Mike.Andrewjeski@businesswire.com> wrote:

> Here's the mysql query:

> select nodes.name, GROUP_CONCAT(node_groups.name) from node_groups,
> node_group_memberships, nodes where nodes.id =
> node_group_memberships.node_id and node_groups.id =
> node_group_memberships.node_group_id and nodes.name IN (SELECT name
> from nodes) group by nodes.name order by nodes.name")
>
> What I'm having an issue with is the IN Clause.  Not sure how to
> do that in psql.

That query looks fine as it is if you just replace this:

  GROUP_CONCAT(node_groups.name)

with this:

  string_agg(node_groups.name, ',')

If that doesn't work, please show a test case where you provide SQL
code to create and populate the tables with minimal columns and
rows.  Show your query, explain what you think the results should
be, and show what you are getting instead.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

Please Note:

The information in this Business Wire e-mail message, and any files transmitted with it, is confidential and may be legally privileged. It is intended only for the use of the individual(s) named above. If you are the intended recipient, be aware that your use of any confidential or personal information may be restricted by state and federal privacy laws. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this e-mail message. If you have received this e-mail in error, please notify the sender and delete the material from any computer.