| From: | Indraneel Majumdar <indraneel(at)www(dot)cdfd(dot)org(dot)in> |
|---|---|
| To: | Fredrick Bartlett <palmtreefrb(at)earthlink(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Select between two databases |
| Date: | 2000-09-25 07:01:35 |
| Message-ID: | Pine.SGI.3.96.1000924235807.98340A-100000@www.cdfd.org.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Not working, but thanks anyway. Can anyone point out the relevant area of
the source where queries are handled?
Thanks,
Indraneel
On Sun, 24 Sep 2000, Fredrick Bartlett wrote:
> Not sure if same can be accomplished with different servers.
> Try the following for database's on one server, use alias & dot notation...
>
> select a1.colA1 from
> myDatabase1.tableA1 a1
> where a1.A2 in (select b1.colB1 from myDatabase2.tableB1 b1)
>
/************************************************************************.
# Indraneel Majumdar ¡ E-mail: indraneel(at)123india(dot)com #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics, #
# Hyderabad, India - 500076 #
`************************************************************************/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Meszaros Attila | 2000-09-25 16:56:16 | Subqueries in from clause? |
| Previous Message | Philip Warner | 2000-09-25 01:48:03 | Re: [HACKERS] RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef? |