[ADMIN] Mail about typecast

1999-06-14 Thread Vikrant Rathore
Dear friends, I want to run a query : vikrant=> select date_part('epoch','12 hours'::timespan)::float4; It returns a error message ERROR: function dtof(float8) does not exist But i want to use typecast since the result of this query will be used to update a field of type float4. I have ch

[ADMIN] Mail about duplicate rows

1999-06-06 Thread Vikrant Rathore
I am trying to append a table radius from another table radiustemp, both having the same structure, but want to append only those tuples from radiustemp which are not there in radius. The size of the table can be up to 165 MB. So anyone can suggest me a better way of doing this. The structure if

Re: [ADMIN] maximum attribute record.

1999-02-02 Thread Vikrant Rathore
Dear Samil, If your query is bigger than 8192 bytes then libpq simply truncates it without giving any warning Vikrant Rathore On Tue, 2 Feb 1999, Postgres GOD wrote: > > i would like to know what is the maximum attribute record that can class > can accomodate. > > i'm

[ADMIN] Mail For database backup and restore

1998-10-13 Thread Vikrant Rathore
I would like to have a help that how can i take the backup and restore the database of postgres on a daily basis. Vikrant Rathore Neuronet [EMAIL PROTECTED]