From: | Ray O'Donnell <ray(at)rodonnell(dot)ie> |
---|---|
To: | stan <stanb(at)panix(dot)com>, 'PostgreSQL' <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: SELECT returnig a constant |
Date: | 2019-10-15 16:15:00 |
Message-ID: | bf419783-8315-95cd-9ea1-504e2de50510@rodonnell.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 15/10/2019 15:01, stan wrote:
> Thanks, as you can see from my SOLVED reply, I go that part figured out.
> Now I am trying to figure out how to complete this. The SELECT returns more
> than 1 row, and when I put that in the VALUES clause this does not work.
Please reply to the list, rather than to me - reply-all should do the
trick. :-)
You're using cross-joins, which returns the cartesian product of the
tables concerned, without any WHERE clause.... so if the tables are big
you'll return a LOT of data.
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray(at)rodonnell(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Lewis | 2019-10-15 16:32:03 | Re: Securing records using linux grou permissions |
Previous Message | David Gauthier | 2019-10-15 16:07:30 | Securing records using linux grou permissions |