| 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: | Whole Thread | Raw Message | 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 |