[SQL] Data Calculation

2003-09-29 Thread Ogden
students that match the criteria and put their IDs into a temporary table and pass the name of this table name to the other perl programs. Is there a way to bypass this creation of a table? Thank you very much for your time. Ogden Nefix ---(end of b

Re: [SQL] numeric problems

2002-11-14 Thread Paul Ogden
Gee, this sounds familiar. See the question ( http://archives.postgresql.org/pgsql-sql/2002-11/msg00191.php ) I posted of a similar nature a couple of days ago. We decided to wait for 7.3/7.4 and in the mean time we're using CAST ( 'constant value' as numeric ). Thanks, Paul

[SQL] RE: [SQL] System´s database table

2002-11-13 Thread Paul Ogden
It's not ERD but I've found the information in the Developer's Guide regarding system catalogs to be useful in the past. This http://www.postgresql.org/idocs/index.php?catalogs.html will get you started. Thanks, Paul Ogden Claresco Corporation > -Original Message--

Re: [SQL] Inconsistent or incomplete behavior obverse in where

2002-11-12 Thread Paul Ogden
omeone knows > > of a better approach, or can point us to documentation of build or > > run-time configuration that affects the query planner where this > > issue is concerned, it would be much appreciated. > > Hopefully someone else will respond to your message as

[SQL] Inconsistent or incomplete behavior obverse in where clause

2002-11-12 Thread Paul Ogden
be a problem? We are looking to maintain a high degree of portability in our application code, and while "CAST ( expression as type )" is fairly portable, no one here feels that it is a portable as column reference = literal/constant value. If someone knows of a better approach, or ca