[GENERAL] Record Sets

2001-09-27 Thread Dale Anderson
I am in the process of trying to convince a Microsoft SQL Guy, that Postgres is what we need to look at, for replacing one of our OTHER ($$) databases. He wants to go with SQL Server. One of his arguments is that PostgreSQL functions don't return Record Sets. Is this true, or can functio

[GENERAL] 7.1 Beta 1 & table size calculation

2000-12-21 Thread Dale Anderson
I am looking at 7.1 beta 1 to see how my application (currently on 7.0.3) will operate under 7.1. To calculate used space, in 7.0.3, I lookup the relpages count for the table in pg_class and multiply it by 8 (8k is my block size). In my testing of 7.1 beta 1, I created a record of length

Re: [GENERAL] Table & Column descriptions

2000-11-30 Thread Dale Anderson
field matches the oid field in pg_attribute (which is the "fields" table for pgsql). On 30 Nov 2000, at 11:17, Dale Anderson wrote: >I am able to add table and column descriptions, and I am also able >to retrieve the table description. The problem is that I can not &

Re: [GENERAL] How to dump from Postgre

2000-06-27 Thread Dale Anderson
The BitBucket on unix is /DEV/NULL, or the place where things will disappear. >>> Herbert Liechti <[EMAIL PROTECTED]> 06/27/00 09:35AM >>> Thomas Lockhart wrote: > > Yeah, it just vanished. Not my fault. The bitbucket ate it. And what is a bitbucket? My dictioniary knows nothing about this word

Re: [GENERAL] DateTime fields

2000-06-27 Thread Dale Anderson
')); INSERT 22825 1 danderso=# select * from test; time 2000-06-28 00:00:00-05 (1 row) danderso=# Thanks, Dale. >>> Tom Lane <[EMAIL PROTECTED]> 06/26/00 05:41PM >>> "Dale Anderson" <[EMAIL PROTECTED]> writes:

[GENERAL] Querying the field types of a table

2000-05-10 Thread Dale Anderson
Is there a way to query the field names and types of a table in either 6.5 or 7.0?? I am writing an application, and in one piece, I need to get the field names and field types of any table. Can this be done??? I have searched both the web and documentation, and I can't seem to find a C func

[GENERAL] Table Names.......

1999-10-05 Thread Dale Anderson
Is there any way to use table names longer than 32 characters Dale.