[SQL] URGENT : free result (libpq++ API)

Hi all, I’m using PG – 7.2.4 on Solaries. I’m using “libpq++” library as client implementation is coded in “C++”.   I’m doing the following : Making the connection to database by creating new object of “PgDatabase” i.e. data = new PgDatabase( “ CONNECTION INFO “);   T

[SQL] Timestamp in PG - 7.1 & 7.2

Hi, I’ve observed this: Here is output from PostgreSQL 7.1.2:   trapdb=# select cast(datetime(1057637700) as timestamp); ?column?  ---  2003-07-08 09:45:00+05:30 (1 row)   Here is output from PostgreSQL 7.2.4:   trapdb=# select cast(datetime

[SQL] time precision.

Hi All, I’m using PG-7.2.4 on Solaries. When I do:   template1=# select time(6576); ERROR:  TIME(6576) precision must be between 0 and 13   Where am I wrong? Pls. help   Thanks, Anagha

[SQL] Seqno. is not btree?

Title: Seqno. is not btree? Hi, I use Postgresql-7.2.4 I’ve created following table: create table vchar (     seqno SERIAL,     col_var character varying (8192)     ); After as many as 2412081 records are inserted,  I shutdown my server.  My every record was inserted programatically by

[SQL] Object based Query Requirement.

Title: Object based Query Requirement. Hi, I use Postgres-7.2.4. and my client is in C++ I need to know the following: As I user libpq++ library, I have to pass the query in the string format only. i.e.’const  char *’ Does Postgres support object based query? i.e. User should make the obj

[SQL] database & table size

Title: database & table size Hello , Here is something I’ve found related to database & table size My databse name is ’test’ and table name is ‘cdrrec’. 1.  Following will give oids & database test=# select datname, oid from pg_database;    datname   |   oid -+-

[SQL] Urgent Help : Use of return from function/procedure.

Title: Urgent Help : Use of return from function/procedure. Hi, I'm new to postgres and using version 7.2.4 I've created a trigger and function which does the following:     trigger 'T' fires after insert on a spcific table takes place and it executes function 'F' Function 'F' retur

Re: [SQL] [ADMIN] Latest transcation

CTED] Sent: Thursday, June 19, 2003 7:26 PM To: Anagha Joshi; [EMAIL PROTECTED] Subject: Re: [ADMIN] Latest transcation -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 18 June 2003 22:16, Anagha Joshi wrote: > Is there any way to know programatically which is the latest > insert/

Re: [SQL] [ADMIN] Latest transcation

Info contains the details like time of insertion of a row and data in that row. I think this sufficely explains what I want. -Anagha -Original Message- From: Bruno Wolff III [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:00 PM To: Anagha Joshi Cc: [EMAIL PROTECTED] Subject:

[SQL] Create rule/trigger

Title: Create rule/trigger Hi All, Can we create trigger/rule that specifies : Do action ‘Y’     When         inserts/updates to any table in the database ‘X’ occurs? If not, what is the alternate way to do this? Thx. In advance. Anagha