Re: [GENERAL] How I can get the real data type result instead of

2006-03-20 Thread Sigurdur Gunnlaugsson
On Mon, 2006-03-20 at 21:10, Wei Wei wrote: > In a query, there is something like > > order by count(id)/age > > where both id and age are the integer data type. > > >From a query result, I believe the operation count(id)/age yields a integer. > >I need it in real data type. After searching t

Re: [GENERAL] Connect to a database in a .sql file

2005-11-08 Thread Sigurdur Gunnlaugsson
On Tue, 2005-11-08 at 07:31, Assad Jarrahian wrote: > Hi, > Lets say the script is called myDBSetup.sql > > And the script contains: > > //CREATE DATABASE section > //CREATE USERS SECTION > //COnnect to db > //CREATE TABLES, FUNCTIONS etc. > > this script will be called from psql. The user w