[GENERAL] how to pass tablename to a function

2014-09-04 Thread A L .
Hi, All I like to pass the tablename to function but not using execute clause, here is my script CREATE OR REPLACE FUNCTION functions.pgsql_event_unpack_batch(IN _tbl text, IN jobid bigint, IN jobtime timestamp with time zone, IN startid bigint, IN stopid bigint) RETURNS TABLE(events bigi

Re: [GENERAL] Problems with plpgsql and FOR loops

2004-06-05 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Bill Moran , I know the correct solution is to use the same version to develop on that I'm using to test. So I'm going to downgrade my version to 7.3.4 for now ... but this doesn't solve my biggest problem: getting the FOR loop to work. It appears from the error that the parser is getting c

Re: [GENERAL] boolean to int

2004-03-15 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Mage , I'm wondering why pgsql doesn't support boolean typecasts like select true::int; Many client applications including php assign 1 to true and 0 to false This was a issue PHP < 4.2 + < PostgreSQL 7.3.x and supports it till now for backward compatibility -- Best Regards, Vishal Kash

Re: [GENERAL] select statement against pg_stats returns inconsistent

2004-02-25 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Shelby Cain , Is this expected behavior or perhaps a bug? For a novice like me can anyone please tell me 1. Will this effect my application developed on PostgreSQL 2. Will my Application break at some point I heavly use the type of queries defined in the post. Would be greatfull for

Re: [GENERAL] embeding postgre

2004-02-20 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear twosk I heard from somone that i could use PostgreSQL, but I cannot find any information that confirms or denies it. AFAIK There was a discussion on the same topic in Dec2003 please search the list and you will geta solution -- Best Regards, Vishal Kashyap Director / Lead Developer, Sai Her

Re: [GENERAL] backup and restore questions

2004-02-19 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Sally Sally , I had a few questions concerning the backup/restore process for pg. 1) Is it possible to dump data onto an existing database that contains data (assumning the schema of both are the same). Has anyone done this? I am thinking of this in order to expediate the data load proces