[SQL] How to write sql to access another odbc source.

2011-10-25 Thread Rich
I have a mumps database with an ODBC connection so I can write queries from other databases. How can I write a sql in Postgresql to access this table to use in my Postgresql reports?

Re: [SQL] How to write query to access another odbc source

2011-10-19 Thread Rich
changed. 2. I cannot find any examples of connecting to another database engine through odbc. Is there any of those. On Wed, Oct 19, 2011 at 11:47 AM, Scott Marlowe wrote: > On Wed, Oct 19, 2011 at 9:19 AM, Rich wrote: > >> I have a mumps database with an ODBC connection so I can w

[SQL] How to write query to access another odbc source

2011-10-19 Thread Rich
> > I have a mumps database with an ODBC connection so I can write queries from > this database. How can I write a sql in Postgresql to access this database > to use in my Postgresql reports? >

Re: FW: [SQL] "=" operator vs. "IS"

2004-06-29 Thread Rich Hall
My question is why is the form "(anything) = NULL" allowed? Since "(anything) = NULL" is always Null, this cannot be what the coder intended. This is much different when comparing two variables, where the coder may have to handle the cases where the variables are Null. Here the comparison is to

Re: [SQL] Virtual records

2004-01-05 Thread Rich Hall
How about a stored procedure that generates the set of records programatically. Rick Kumar wrote: Dear Friends, I am working with Postgres 7.3.4 on RH Linux. Here is a need while developing an Calendar application. I have a scheduled meeting at every month. While opening the calendar next

Re: [SQL] postgreSQL editors

2003-12-31 Thread Rich Hall
can anyone recommend a good editor for postgreSQl wich wil enable me to create functions/stored procedures? I am currently running version 7.4.1 on OS X 10.3 I use PG Manager from EMS Hitech. It is not free but inexpensive. You have everything PostgreSQL-wise at your fingertips. Ver 2.0 was ju